Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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
Highlighted
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)

View solution in original post

5 Replies
Highlighted
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)

View solution in original post

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