topic Re: Set Analysis in QlikView

Set Analysis

Wed, 05 Mar 2014 01:22:57 GMT

Hi,

I am trying to write a set analysis expression like below:

=Sum({<FIS_CAL_WEEK_ID ={">=Max(FIS_CAL_WEEK_ID)-12 <=Max(FIS_CAL_WEEK_ID))"}>} TOTAL_QTY)

The objective sum of Total Quantity where it will start from Maximum week number and will show only 13 weeks in the chart.

Thanks

Re: Set Analysis

Sokkorn — Wed, 05 Mar 2014 01:38:12 GMT

Hi Simky,

Try this

=Sum({<({<FIS_CAL_WEEK_ID = {">=$(=Max(FIS_CAL_WEEK_ID)-12)<=$(=Max(FIS_CAL_WEEK_ID))"} >} TOTAL_QTY)

Regards,

Sokkorn

Re: Set Analysis

maxgro — Wed, 05 Mar 2014 22:54:15 GMT

Sum( {$<FIS_CAL_WEEK_ID = {">=$(=Max(FIS_CAL_WEEK_ID)-12)<=$(=Max(FIS_CAL_WEEK_ID))"} >} TOTAL_QTY)

Re: Set Analysis

Thu, 06 Mar 2014 00:05:02 GMT

Hi Simky,

I've not tested this but I hope it works. I have recently done something similar to create a rolling 12 months. What I will suggest including in your set analysis is ignoring selections on other date fields. In the example below I have added "FIS_YEAR=," to demonstrate what I mean:

=SUM({<FIS_YEAR=, FIS_CAL_WEEK={">=$(=Max(FIS_CAL_WEEK_ID)-12)<=$(=Max(FIS_CAL_WEEK_ID))"}>} TOTAL_QTY)

Regards,

Chris

Re: Set Analysis

Thu, 06 Mar 2014 04:07:46 GMT

This expression is working, thanks for the help

Re: Set Analysis

Thu, 06 Mar 2014 04:08:40 GMT

What is reason of adding other fields? If I have 10 ffilters in a dashboard, do I need to add all?

Re: Set Analysis

Thu, 06 Mar 2014 04:31:10 GMT



try this

=Sum({<({<FIS_CAL_WEEK_ID = {'>=$(=Max(FIS_CAL_WEEK_ID)-12)<=$(=Max(FIS_CAL_WEEK_ID))'} >} TOTAL_QTY)

Re: Set Analysis

Thu, 06 Mar 2014 04:33:03 GMT

Hi Simky,

If you want to ignore all the selections for all 10 filters, it is better to do like this:

= SUM ({1 <FIS_CAL_WEEK={"> = $ (= Max (FIS_CAL_WEEK_ID) -12) <= $ (= Max (FIS_CAL_WEEK_ID)) "}>} TOTAL_QTY)

Constant 1 - represents the full set of all the records in the application.

Re: Set Analysis

maxgro — Thu, 06 Mar 2014 06:32:30 GMT

if possible, when you ask a question and you get an answer that proves right to you, mark as helpful or answer, thanks

Re: Set Analysis

Thu, 06 Mar 2014 16:12:36 GMT

Sure. I have marked your correct answer.

Re: Set Analysis

Thu, 06 Mar 2014 16:13:16 GMT

Thanks for the ans