topic Re: variable date selections in QlikView

variable date selections

kris_vliegen — Fri, 24 Feb 2017 10:33:06 GMT

Hi All,

I have a dashboard wit date-selections (Year, Quarter, Month, week, day)

I have Barcharts with the shop on the x-as and a bar for the selection and a bar for the precious selection.

If the user selects only a year He would like to see in the charts the data of the selected year and the data of the precious year.

If he selects a quarter, he would like to see the data of the selected quarter and the data of the previous Quarter.

and so for the month, week and day.

How Can I do this sipmple. Now I have a chart for ever selection.

regards,

Kris

Re: variable date selections

sunny_talwar — Fri, 24 Feb 2017 10:37:17 GMT

May be use different set analysis based on different selections.

Re: variable date selections

sasikanth — Fri, 24 Feb 2017 10:44:22 GMT

May be use two expressions

DIM: Shop

Exp :sum({$} SALES) (current selections)

Exp: Sum({$1} SALES) Previous Selection)

Re: variable date selections

Anonymous — Fri, 24 Feb 2017 11:00:05 GMT

Just sharing a thought,

Create a variable and put a trigger to update the value of the variable to year, Month, Quarter or etc selected. Create two variables having the text forming the set expression one for Current bar chart and another for previous bar chart.

Use these variables in the expressions.

Re: variable date selections

Anonymous — Fri, 24 Feb 2017 13:16:34 GMT

The best solution by far, which you could customize according to your Dashboard:

https://community.qlik.com/docs/DOC-4313

Re: variable date selections

kris_vliegen — Fri, 24 Feb 2017 14:31:52 GMT

Do you have an example of this?

A trigger on anySelect?

Now I have a graph per dateselection.

To show the year-graph I use this conditional format

=GetSelectedCount(_CalYear)<>0 and GetSelectedCount(_CalQuarter)=0 and GetSelectedCount(_CalMonth)=0 and GetSelectedCount(_CalWeek)=0 and GetSelectedCount(_CalDay)=0