topic Re: Date pickers in App Development

Date pickers

TeodoraBurlica — Mon, 18 Apr 2022 07:49:24 GMT

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?

Re: Date pickers

vinieme12 — Mon, 18 Apr 2022 08:04:16 GMT

you need alternate states not two date fields

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-states-comparative-analysis.htm

Re: Date pickers

TeodoraBurlica — Mon, 18 Apr 2022 09:27:41 GMT

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

Re: Date pickers

vinieme12 — Mon, 18 Apr 2022 09:36:07 GMT

"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

Re: Date pickers

TeodoraBurlica — Mon, 18 Apr 2022 09:47:55 GMT

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.

Re: Date pickers

vinieme12 — Mon, 18 Apr 2022 09:51:54 GMT

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

Re: Date pickers

vinieme12 — Mon, 18 Apr 2022 10:08:38 GMT

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)

Re: Date pickers

TeodoraBurlica — Mon, 18 Apr 2022 11:03:41 GMT

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

Re: Date pickers

vinieme12 — Mon, 18 Apr 2022 11:14:22 GMT

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