Above function is not working if i add more than 2 dimensions in Qliksense

Navars — Tue, 22 Feb 2022 09:34:27 GMT

Hello All,

I have a Table chart, in that i am passing 3 dimensions(DATE_REFRESHED, MODEL, SKU) and one measure(sum(cost)), what i need here is i need to calculate the variance of the measure compared with previous month for the same SKUs.

Sum(USD_MATERIAL_COST)-above(Sum(USD_MATERIAL_COST)) --> if i use this expression and with 2 dim. i am getting the expected result but in my case i have to use the all 3 dim.

attached the sample data (sample_data.xlsx)

Thanks in Advance!!

Re: Above function is not working if i add more than 2 dimensions in Qliksense

Andrea_Spinetti — Tue, 01 Mar 2022 09:23:19 GMT

Hello @Navars, can you attach a sample Qlik Sense App where you have developed the draft of the table you are talking about? I'm struggling to understand how you compare/group the fields in your environment. Thanks!

topic Re: Above function is not working if i add more than 2 dimensions in Qliksense in App Development

Above function is not working if i add more than 2 dimensions in Qliksense

Re: Above function is not working if i add more than 2 dimensions in Qliksense