Re: How to use Set Analysis in above case - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-12-28

Hi,

How to do this example ?

Thank you !

Report Inappropriate Content · ‎2011-12-28

Alternative ?

rbecher · ‎2011-12-28

I would transpose the data into daily rows. Then you can just summarize it with previous( ) function (order by date desc)..

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2011-12-29

Hi,

I updated the example.

rbecher · ‎2011-12-29

Expression for tomorrow is: below(count(NoCommande))

To ensure the right figures the sort of DateCommande should set to Ascending.

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2011-12-29

Thank Ralf !

How to use it for example2.qvw ?

Thank you once again !

rbecher · ‎2011-12-29

I don't see what is wrong with it..

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2011-12-29

I suggest you try the rangecount function. Since I'm not quite sure what the expected end result should be, I would encourage you to read the Help topic for the range functions used in conjunction with the above, below, before and after functions. The form of the expression will be something like:

rangecount (below(count({SET ANALYSIS stuff} yourfieldname),yourstartingrow,yourinterval))

Set Analysis can be applied to the count function and make sure to study the effect of the TOTAL keyword in these functions.

Report Inappropriate Content · ‎2011-12-30

Thank you very much for your help !