Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max Date in List Box?

I used an expression to get max date from my timestamp:

COUNT(IF(AGGR(NODISTINCT MAX(INSTC_CAPTR_TSTMP),COM_BUSN_ID)=INSTC_CAPTR_TSTMP,COMU_BUSN_ID))

I created a List Box from the above expression which contains all my max timestamp dates but they are listed in the List Box as follows:

7/23/2012 12:00:57AM      0

7/23/2012 12:04:33AM      0

7/24/2012 12:18:22AM      1

7/24/2012 9:22:27AM        0

7/24/2012 9:36:33AM        1

I want to display in the List Box one value of 'Y' for all the records above where there's a '1' but how do you do that?

Labels (1)
1 Reply
Not applicable
Author

The easiest way would be to write it in the expression in the form IF(X=X,'Y'). Here is an example.