Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

1 Solution

Accepted Solutions
11 Replies
sunny_talwar

May be implement The As-Of Table

sunny_talwar

or share a sample to show your issue? I wonder why you can't use Above or Below?

uacg0009
Partner - Specialist
Partner - Specialist

Hi Chiara,

if the measure is cumulative like you said, then I think the discrepancy between months is just the delta, isn't it?

Thanks

Aiolos

c_pannese
Partner - Creator
Partner - Creator
Author

It works!

I cannot use "Above" or "Below" because they don't work with the selection on a single month.

Thank you very much for you help!

Bye

hitman1967
Contributor
Contributor

Hi Chiara,

this is an implementation with  the AsOfTable. I hope this can help you.

BR,

Sandro

sunny_talwar

There are ways to make Above/Below work with selection of Month also...

Above(Sum({<Month>}Sales)) * Avg(1)

Here Sum(Sales) will ignore selection in Month field to pull the value of previous dimension to this dimension and Avg(1) will make sure that only current dimension is shown as Avg(1) = 1 for current selections and 0 for out of selections

c_pannese
Partner - Creator
Partner - Creator
Author

Hi Sunny,

at the moment I have a new issue.

I need to create the same process but for successive months.

In january 2017 I have to use the value of  february 2017 and in other case march 2017.

Is it possible?

Thank you!

sunny_talwar

Should be possible... can you elaborate a little more and may be share a sample?

c_pannese
Partner - Creator
Partner - Creator
Author

Here is an example.

I have to reproduce the same  behavior of the "RESULT A" and "RESULT B".

I could sum the mesures using "MonthDiff" but how can I get the numerator?