topic Re: expression wrong in QlikView

expression wrong

Wed, 23 Sep 2015 12:36:41 GMT

i want annual growth rate for that i write this expression but it show the error

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)-1) ,'#,##0.00%'

Thanks

Josna

Re: expression wrong

alexandros17 — Wed, 23 Sep 2015 12:39:32 GMT

Perhaps is this:

Num(

(

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)

)

-1 ,'#,##0.00%')

Re: expression wrong

sunny_talwar — Wed, 23 Sep 2015 12:39:46 GMT

Try this:

=Num(((Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User))-1) ,'#,##0.00%')

Re: expression wrong

maxgro — Wed, 23 Sep 2015 12:41:01 GMT

(

Sum ({<Market_Year={"2016"}>} Market_Dollars_End_User)

Sum ({<Market_Year={"2013"}>} Market_Dollars_End_User)

)

-1

and format the expression in number tab

Re: expression wrong

Wed, 23 Sep 2015 12:41:24 GMT

is Mandatory by using NUM()

Re: expression wrong

alexandros17 — Wed, 23 Sep 2015 12:47:44 GMT

Sorry but the useful answer is identical to mine, I have answered before ....

Re: expression wrong

sunny_talwar — Wed, 23 Sep 2015 12:48:43 GMT

If you are specifying the format at the end, you do need the Num() function. Else you can look at maxgro‌'s suggestion

Re: expression wrong

Wed, 23 Sep 2015 12:52:02 GMT

hi sunny,

i need your help on the thread 181882.

please have a look

Re: expression wrong

sunny_talwar — Wed, 23 Sep 2015 13:11:32 GMT

I am working off of a personal edition of QlikView and won't really be able to open your qvw. I see a lot of experts are already to trying to help and I am sure they will def. be able to help you out.

Best,

Sunny