topic Re: wrong percent value in straight tbl in QlikView

wrong percent value in straight tbl

surajap123 — Fri, 16 May 2014 13:47:38 GMT

Hi All,

I have the below three expressions in the straight table.

=(sum({<Year={$(=Max(Year))}>}ATotal)+ sum({<Year={$(=Max(Year))}>}STotal))/1000 //show value in thousands

=(sum({<Year={$(=Max(Year)-1)}>}ATotal)+ sum({<Year={$(=Max(Year)-1)}>}STotal))/1000 //show value in thousands

=(Column(2) - Column(3)) / Column(2)

-the first one is to show YTD Sales for current year.

-the second one shows YTD sales for previous year

-the third one is to show the YTD Variance.

=For the third expression i have done percentage settings (ie. Number tab--> fixed to 1 and enabled 'show in percentage'.

But, if you see the screen shot below, few percent value are above 100%, which seems wrong.

Please let me where i am doing wrong.

jonathandienst — Fri, 16 May 2014 14:08:36 GMT

Looks like its working properly to me. Look at the last line. Your variance expression is:

(7 - 244) / 7 = -237/7 ~ -3000%

HTH

Jonathan

jonathandienst — Fri, 16 May 2014 14:09:43 GMT

Perhaps you meant to calculate (244 - 7) / 244?

surajap123 — Fri, 16 May 2014 14:19:21 GMT

I was confused with the results initially. You are right, the result are correct. Thanks...