Qlikview Format textbox expression as percentage to 3 decimal places

Question

I am trying to show percentage increase / decrease based on week number for 2018 v 2019 with an expression in a textbox in Qlikview: Here is my expression:

= num(Sum({<Year = {$(=Max(Year))}, 
Week = {"$(=Week(Today()))"}>}Retail) - Sum({<Year = {$(=Max(Year)-1)}, 
Week = {"$(=Week(Today()))"}>}Retail)) / num(Sum({<Year = {$(=Max(Year)-1)},
Week = {"$(=Week(Today()))"}>}Retail),'##0 %')

No matter what i try i end up with -0.38877082 etc.

What am i doing wrong?

score 0 · Accepted Answer · answered Feb 15 '19 at 12:17

0

Please fix parenthesis and formatting:

= num(Sum({}Retail) - Sum({}Retail) / Sum({}Retail),'##,#0.00 %')

answered Feb 15 '19 at 12:17

Hubert Dudek

1,666
1
13
21

Hi Hubert, i am getting the correct calculation with this: = num(Sum({}Retail) - Sum({}Retail)) / num(Sum({}Retail),'##0.000%') but still not formatting to 3 decimal places. – PA060 Feb 15 '19 at 13:03
please try ##,#0.00 % – Hubert Dudek Feb 15 '19 at 13:04
1

Hi Hubert: Got it with this: '#,##0.000%' Thank You!! – PA060 Feb 15 '19 at 13:14

Qlikview Format textbox expression as percentage to 3 decimal places

1 Answers1