Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
divya_anand
Contributor II

Selection between two timestamps

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.

 

calendar.PNGscreenshot 1output.PNGscreenshot2

1 Solution

Accepted Solutions

Re: Selection between two timestamps

Check the attached

5 Replies

Re: Selection between two timestamps

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

divya_anand
Contributor II

Re: Selection between two timestamps

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

Re: Selection between two timestamps

Check the attached

divya_anand
Contributor II

Re: Selection between two timestamps

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

Superb Smiley Happy