Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
garry107
Contributor
Contributor

set a dimension with Max and min values

Hello,

Have a question,

how to work this situation.

I have a table with the below fields:

Dimension1,

Date,  MM/DD/YYYY HH:MM:SS

Landmark, 'A'-'Z'

Start Timestamp,MM/DD/YYYY HH:MM:SS

End Timestamp.MM/DD/YYYY HH:MM:SS

I have to distribute DImension 1 into Day and Night

if ( ( Date greater than min({<Landmark = 'D'>}Start Timestamp)

and

( Date less than max({<Landmark = 'Y'>} End Timestamp) ),

'Day','Night').

How can this be achieved.

Thanks,

Garry

1 Reply
sunny_talwar

Is this something you are looking to do in the script or front end app? Also, are you able to share a small sample to show your data looks like?