topic Re: Default in Set analysis in QlikView

Default in Set analysis

Thu, 12 Mar 2015 08:41:34 GMT

Hi,

I have a Requirement to create a report

- which will have defaulted to max year on opening the document

( Achieved it using triggers on open)

- A report which compares current year to previous year comparision of counts

( Achieved it using set analysis for Current year as - =Sum({Year={$(=GetFieldSelections(Year))}>} issuecount)

and year ago counts using =Sum({Year={$(=GetFieldSelections(Year)-1)}>} issuecount)

)

But when we clear the selections the chart dispalys nothing.

my requirement here is to default the graph to max year when all the selections are cleared.

Please can you help

Thanks

Re: Default in Set analysis

tresB — Thu, 12 Mar 2015 08:45:23 GMT

Try like:

Sum({<Year={$(=Max(Year))}>} issuecount)

and

Sum({<Year={$(=Max(Year)-1)}>} issuecount)

Re: Default in Set analysis

simenkg — Thu, 12 Mar 2015 08:47:10 GMT

Sum({Year={$(=max(Year))}>} issuecount)

Sum({Year={$(=max(Year)-1)}>} issuecount)

Re: Default in Set analysis

maxgro — Thu, 12 Mar 2015 08:48:35 GMT

try with

sum({$<Year={$(=max(Year))}>} issuecount)

Re: Default in Set analysis

Thu, 12 Mar 2015 08:59:50 GMT

Thanks Tresesco for quik help.

I tried it and it worked. I would like to understand its behaviour though.

so when we open the dashboard it takes max year displayes results.

when we select any other year in the list box, is that replacing the max year by the field value selected?

does that mean that qlikview is not checking the expression as is ? if it checks as is, it has to always give the max year as the year available in my entire dataset but it doesnt do that.

please help me with this understanding

Thanks

Re: Default in Set analysis

simenkg — Thu, 12 Mar 2015 09:10:31 GMT

When no selections are made then all possible values for Year are in the "Year Array".

Selecting a Year/Years will reduce the "Year Array" to those selected values. Selecting another field could also reduce the array because of the associative model.

The Max(Year) function will return the biggest numeric value in the "Year Array".

If you want the function to give you the biggest numeric value in the "Year" field regardless of selections then the expressions becomes:

Max({1} Year). The {1} tells QlikView to disregard user selections.

in expression:

Sum({<Year={$(=Max({1} Year))}> issuecount)

Re: Default in Set analysis

jyothish8807 — Thu, 12 Mar 2015 09:10:35 GMT

Hi Swapnil,

When ever you select a year QV consider that Year and fetch data corresponding to that year and Year-1.

If you take year as dimension then you can see it will display data for only Max Year and max Year-1 and other years will have 0 corresponding to that.

Regards

Re: Default in Set analysis

tresB — Thu, 12 Mar 2015 09:11:48 GMT

Max(Year) - returns the max of year out of the years that are in the scope. Now 'in the scope' means -

- all the years when no year is selected

- a particular one or multiple years which are selected

So it is actually checking the expression. You have to just understand the 'in the scope' concept. Hope this helps.

Re: Default in Set analysis

Thu, 12 Mar 2015 09:16:58 GMT

Excellent. Thanks for the detailed explanation Simen

Regards