Search code examples
textboxexpressionpercentageqlikview

Qlikview Format textbox expression as percentage to 3 decimal places

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?

Solution

  • Please fix parenthesis and formatting:

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