variable date selections

[kris_vliegen]

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

[sunny_talwar]

May be use different set analysis based on different selections.

[sasikanth]

May be use two expressions

DIM: Shop

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

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

[Anonymous]

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.

[Anonymous]

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

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

[kris_vliegen]

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