Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
selvapraveen
New Contributor II

Date Value in text box must ignore selection

I have  table

Table A

Date      Process1              Process2              Process3

01/01/2016         C                             X                             C

02/01/2016         C                             X                             C

03/01/2016         C                             C                             C

04/01/2016         N                             X                             N

05/01/2016         N                             X                             N

06/01/2016         N                             N                             N

Now I need to display the date in which the Process2  has value C

And the date in which the process2 has value N . These date values must not change with date selection in the list box .

Can anyone help on this .

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Value in text box must ignore selection

Maybe like

=Max({<[Process 2]= {'C'}, Date= >}  Date)

resp.

=Max({<[Process 2]= {'N'}, Date= >}  Date)

5 Replies
MVP
MVP

Re: Date Value in text box must ignore selection

Maybe like

=Max({<[Process 2]= {'C'}, Date= >}  Date)

resp.

=Max({<[Process 2]= {'N'}, Date= >}  Date)

Re: Date Value in text box must ignore selection

What happens with there are multiple dates where Process2 has C in them. Similarliy what happens when you have multiple N? It would be great if you can provide some more details if what Stefan has provided doesn't work for you

manucamon
Valued Contributor III

Re: Date Value in text box must ignore selection

Hi selvapraveen,

Try this

=Max(TOTAL {1<[Process 2]= {'C'}>}  Date)

=Max(TOTAL {1<[Process 2]= {'N'}>}  Date)


Regards!

selvapraveen
New Contributor II

Re: Date Value in text box must ignore selection

Actually that works for me because i need the latest date with Process 2 as C

Re: Date Value in text box must ignore selection

Awesome!! I am glad Stefan's solution worked out for you