topic Set Analysis in QlikView

Set Analysis

fcecconi — Tue, 21 Feb 2017 21:53:35 GMT

I am not sure if this can be accomplished, but I need to create a set of analysis for not the current year.

I am using =avg({ < Discharge__PREV_YTD ={1}>}Value)

However, the data is relatively new and we don't have data in the table for Jan and Feb yet, so there really isn't any data yet for a previous YTD.

Any way around this?

Re: Set Analysis

sergio0592 — Tue, 21 Feb 2017 22:03:58 GMT

You want average for the previous year of the selected year, that's it?

If it's the case, try : avg({$<Discharge__PREV_YTD={$(=Discharge__PREV_YTD-1)}>} Value)

Re: Set Analysis

Anil_Babu_Samineni — Wed, 22 Feb 2017 02:31:31 GMT

Data consumes as per your data

Even, If you don;t have Jan and Feb data if you are selecting December which data you want to show. You meant it is you need to show as November data as you think. This is just assuption

Avg({<Month = {'$(=Max(Month)-1)'}>}Value)

Re: Set Analysis

fcecconi — Wed, 22 Feb 2017 14:12:21 GMT

I want to use the Discharge_PREV_YTD flag. This is updated on every load. Since the earliest data is Mar 2016, Jan and Feb 2016 are missing. I would like to create an expression that handle this until data is loaded and not hard code anything. I am also anticipating that the users would like to do month vs month comparison, so I need to figure this out.

Re: Set Analysis

Anil_Babu_Samineni — Wed, 22 Feb 2017 16:17:45 GMT

Can you elaborate the Flag Discharge__PREV_YTD ??

Re: Set Analysis

fcecconi — Wed, 22 Feb 2017 16:21:40 GMT

It is just a value of 0 and 1 to indicate if the date should be included. For example 2/22/2016 should be flagged as 1 to show that it is a date in the previous YTD range.

Re: Set Analysis

sergio0592 — Wed, 22 Feb 2017 16:41:07 GMT

I managed this case with a flag defined in the ETL. And for all my expressions, i have :

-if user select current month (not over), i use the flag for compare same period for previous year.

-if user select a past month (over), i don't use flag.

I have two flags, one for month and one for year (cumulate from 01/01).

In the attached file, you have what the two flags make on my Temporal Table (at 20/02/2017).

Is it that you're trying ton achieve??

Re: Set Analysis

fcecconi — Fri, 24 Feb 2017 19:42:28 GMT

Jean

We were also setting flags. It appears to have been an issue with the variable we were using. If we take the code and enter it into the object, it works fine.