Date pickers

[TeodoraBurlica]

Hi!

I need to add two date pickers in one dashboard. Then I need to make a barchart to compare the data from the period selected in the first date picker with the one selected in the second. I've already had two date fields, but I don't know how to select both so that they don't affect each other.

Do you have any idea how to do this?

[vinieme12]

you need alternate states not two date fields

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

[TeodoraBurlica]

Thank you for the answear! I've tried, but the second measure doesn't work.

[vinieme12]

"second measure doesn't work"? Do you need help with an expression?please post the expression you need help with

Watch some videos on YouTube on how to use alternate states

https://youtu.be/tsbnG3tOdR4 

There are plenty more videos on alternate states

[TeodoraBurlica]

I have 2 states: Time range 1 and Time range 2. I've applied time range 1 on the first Date Picker , and time range 2 on the second. Then I've created two master items with these formulas: Sum({[Time Range 1]}Sales) and ({[Time Range 2]}Sales) then I've added in a table. First measure displays correct values, but the second one doesn't.

[vinieme12 · Accepted solution]

Don't create master measures

Just create two charts both with same measure = sum(Sales)

Drag and drop state TimeRange1 on chart 1 and drag and drop TimeRange2 on chart2 

Now selection s in date picker with TimeRange1 should correspond with chart with state TimeRange1

And selection in datepicker2 with state TimeRange2 should correspond to chart with state TimeRange2

I suggest you watch some videos, you are definitely missing a step somewhere

[vinieme12]

I have 2 states: Time range 1 and Time range 2. I've applied time range 1 on the first Date Picker , and time range 2 on the second. Then I've created two master items with these formulas: Sum({[Time Range 1]}Sales) and ({[Time Range 2]}Sales) then I've added in a table. First measure displays correct values, but the second one doesn't.

is this a typo in the measure definition? should be Sum({[Time Range 2]}Sales)

[TeodoraBurlica]

Yes, it is sum in definition. I'll watch more videos, thank you for the help.

[vinieme12]

can you please close this thread by marking a response as solution