Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
c_pannese
Partner - Creator
Partner - Creator

Delta between months in Set Analysis

Hi ,

I have a situation like this:

DATECodeN. PieceAmount
201705A550
201705B8100
201705C675
201706A1280
201706B15122
201706C1090
201707A19101
201707B22134
201707C2198


The Date format is 'YYYYMM' .

Every month has about 130.000 rows and the Measures are cumulative from the previous month. What I need is calculate the Delta between months and I cannot use function like "Before" or "Above".

So I thought to use Set Analysis but when I use Date-Function for filter by the previous month the sistem returns me 0 or in others cases the identical value of the month instead of the previous.

I hope to be exhaustive.

Can someone help me please?

Thank you All.

11 Replies
s_santalucia
Partner - Creator
Partner - Creator

Hi Chiara,


this is possible if you remove the where condition in

<< as-of-table>>


Regards

Stefania

c_pannese
Partner - Creator
Partner - Creator
Author

Hi Stefania,

you're right!!

thank you!

Bye Chiara