topic Re: Selection between two timestamps in QlikView

Selection between two timestamps

divya_anand — Sat, 16 Nov 2024 04:29:35 GMT

Hi,

I would like to create a scenario where I am able to select two timestamps and search by the range between these two timestamps. For e.g., I have created this calendar (screenshot 1) where I get to choose the date & time range. Now i need to apply the condition (within button 'Time Periode Selection') to select all timestamps between these 2 values. So for the below selections I must be able to fetch the output shown in screenshot 2.

I have attached a sample QVW for reference. Anybody has an idea on how to write the condition for this?

Thank you.

screenshot 1screenshot2

Re: Selection between two timestamps

sunny_talwar — Mon, 11 Feb 2019 13:28:07 GMT

Are you looking for dashboard wide selection using triggers? Or just chart wide selection using set analysis?

Re: Selection between two timestamps

divya_anand — Tue, 12 Feb 2019 03:43:41 GMT

Hi Sunny,
I am looking for a dashboard wide selection, similar to calendar functionality.

Re: Selection between two timestamps

sunny_talwar — Tue, 12 Feb 2019 14:33:49 GMT

Check the attached

Re: Selection between two timestamps

divya_anand — Fri, 15 Feb 2019 09:26:55 GMT

Hi Sunny,

Thank you very much. With minor modifications based on my production report formatting, the expression behind the button fit perfectly. Thank you again.

Re: Selection between two timestamps

sunny_talwar — Fri, 15 Feb 2019 12:15:00 GMT

Superb 🙂

Re: Selection between two timestamps

fabdulazeez — Wed, 08 Jan 2020 09:22:53 GMT

Can we achieve same in qlik sense