topic How to get next column value with after() function in Qlik Sense in App Development

How to get next column value with after() function in Qlik Sense

umuto — Sun, 19 May 2019 15:16:32 GMT

Hi,

I am using same dataset. I have tried these expressions Sum(DEGER) and After(Sum(DEGER)) in qlikview. It works perfectly.

I want to see first week value next to second week value to calc change rate. Please check CATEGORY 1.

When I try that in Qlik Sense It doesn't work perfectly. Is that bug in Qlik Sense? Does anybody know how to solve?

Thanks,

Re: How to get next column value with after() function in Qlik Sense

Anil_Babu_Samineni — Sun, 19 May 2019 15:01:42 GMT

Can you please post QVW? If so, we can help in Qliksense.

Re: How to get next column value with after() function in Qlik Sense

umuto — Sun, 19 May 2019 15:19:40 GMT

I attached QVW and QVF files Can you check please?

Re: How to get next column value with after() function in Qlik Sense

Anil_Babu_Samineni — Sun, 19 May 2019 16:03:36 GMT

Is this you are expecting?

Re: How to get next column value with after() function in Qlik Sense

umuto — Sun, 19 May 2019 16:47:05 GMT

Yes but Its already working in qlikview. I have to develop that in Qlik sense. Please check my second image I couldn’t get first week value next to second week because second week there is no value for CATEGORY 1.

Did you change something in expression? I need to test in Qlik Sense.

Re: How to get next column value with after() function in Qlik Sense

Anil_Babu_Samineni — Mon, 20 May 2019 04:26:29 GMT

Quite bug to me as well. Check If @marcus_sommer can help you !!

Re: How to get next column value with after() function in Qlik Sense

jonathandienst — Mon, 20 May 2019 05:53:03 GMT

Did you try:

After(TOTAL Sum(DEGER))

Re: How to get next column value with after() function in Qlik Sense

umuto — Mon, 20 May 2019 11:04:06 GMT

Hi @jonathandienst
I have tried but It's not what I need.

Re: How to get next column value with after() function in Qlik Sense

sunny_talwar — Mon, 20 May 2019 11:35:50 GMT

The only way I think this can be done is by Generating Missing Data. In your case, the combination of REGION 1, CITY A, RUT = A, KATEGORI = CATEGORY 1, and YILHAFTA = 2019-02 doesn't exists... QlikView is able to handle it, but Qlik Sense isn't.