topic Re: Two Pass Calculation ? in App Development

Two Pass Calculation ?

girard_ben — Mon, 06 May 2019 13:19:18 GMT

Dear All,

I have a tricky data modelization to reslove. I build successfully monthly and weekly stock reports.

So now users want to select any date of the calendar. I can handle this request.. I have all the data movements ^^ (and it's working very well.)

But the tricky part, its the "season" analysis: for some reasons.. some products do not have always the same season over the time...

Please a simplified version of my data

The referencial: where we can see that the product "P1" has it's season updated the 1st of June

Here the expected results :

Because of the P1 product is carry over the 2nd of June.. it's season for the analysis should be "Carry Over".

if someone has some ideas how to do that in QlikSense he is welcome. Maybe there is a "name" for this king of request, I did some search but I did not find anything relevant..

I added an excel sheet with some dummy data

Re: Two Pass Calculation ?

lalphonso — Sat, 11 May 2019 03:49:16 GMT

Hi @girard_ben

If I read your analysis correctly - I think you would require the intervalmatch() function in Qlik. This will give you the season value based on a date range.

Good luck.

Re: Two Pass Calculation ?

girard_ben — Mon, 13 May 2019 15:55:21 GMT

Hi Lalphonso

The "IntervalMatch" is only in the "Script Part" , isn't it ?

I want to achieve this functionality in the presentation/layer part ...

It's seems like an aggregatable ... were the value of the field of the "Season" is depending of the last date of the range (per product)

regards

Re: Two Pass Calculation ?

dplr-rn — Mon, 13 May 2019 18:49:17 GMT

What you are describing seems to be slowly changing dimensions.
check below links

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187
https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928