topic Getting the max date values in chart in QlikView

Getting the max date values in chart

Fri, 29 Aug 2014 17:04:30 GMT

Hello Everyone,

This may be simple but I'm having a problem:

I have a table like:

ID DATE CODE

1 07/21/2013 A1
1 07/21/2013 B1

1 - C1

1 D1

2 07/25/2013 A1

2 07/28/2013 A2

2 07/28/2013 B1

3 08/01/2013 C1

So, I wanted to display chart based on max of date which should show results like:

ID DATE CODE

1 07/21/2013 A1

1 07/21/2013 B1

2 07/28/2013 A2

3 08/01/2013 C1

So, based on the latest date, the table should show the values for that specific ID and Code.

Re: Getting the max date values in chart

JonnyPoole — Fri, 29 Aug 2014 17:13:17 GMT

You can do that. When you add an expression, create an IF statement like this. If the row is not the maximum date for the ID, it will evaluate as null and be auto suppressed

if( Date=max( total <ID> Date), <expression> ))

Re: Getting the max date values in chart

Fri, 29 Aug 2014 18:34:48 GMT

Thanks Jonathan,
but seems like it is not working. Any other suggestions?

Thanks.

Re: Re: Getting the max date values in chart

gmoraleswit — Fri, 29 Aug 2014 19:01:07 GMT

Jonathan's solution is correct, please check attached.

Re: Re: Getting the max date values in chart

JonnyPoole — Fri, 29 Aug 2014 19:08:48 GMT

i used your data set and came up with this. Let me know if there is a different data set that illustrates your 2nd issue and i'll fix it. thanks !

Re: Getting the max date values in chart

Fri, 29 Aug 2014 19:13:04 GMT

Sorry guys,

Confusion on my part. You both are awesome! Thanks Jonathan and Gabriela.