topic How to show only max date values? in QlikView

How to show only max date values?

Mon, 15 Jun 2015 10:18:02 GMT

Hi,

I have data as below in excel.

NO	From	To	Name	date
432434	Sales	Funcorner	XX	06/05/2015 12:56
432434	Sales	Funcorner	XX	12/06/2015 15:04
432434	NO	Road Tax	XX	12/06/2015 14:30
432434	Workshop	Road Tax	XX	13/04/2015 16:15

I need table to show max date when To ='Road Tax' (in this case the table should show 12/06/2015 14:30) and max date when To ='Funcorner' (in this case the table should show 12/06/2015 15:04)

Please can anyone suggest me how to do this.

Thanks.

Re: How to show only max date values?

avinashelite — Mon, 15 Jun 2015 10:20:26 GMT

try like this in the chart:

Aggr(max(date),to)

where date and to are the column names

Re: How to show only max date values?

Mon, 15 Jun 2015 10:20:45 GMT

I always do it in the load script by using the Max statement.

I haven't figured out a better way as yet.

Re: How to show only max date values?

Mon, 15 Jun 2015 10:21:41 GMT

Thats a better way than mine!

Re: How to show only max date values?

Mon, 15 Jun 2015 10:21:46 GMT

Take dimension as 'To' and expression as max(date). This should work i guess.

Re: How to show only max date values?

avinashelite — Mon, 15 Jun 2015 10:26:59 GMT

Hi Peter,

If do not require the data slicing to the nth level ,we can always reduce the data in the script itself that a better way but if you don't want the data to reduce we can handle it in the front end

Re: How to show only max date values?

Mon, 15 Jun 2015 10:29:35 GMT

Thanks. will this work if there are multiple NO values? I have tried it. it is showing over all max date values. when I click individual NO values table is showing blanks.

Re: How to show only max date values?

Mon, 15 Jun 2015 10:31:52 GMT

Thanks. tried this and it worked.

Re: How to show only max date values?

avinashelite — Mon, 15 Jun 2015 10:34:42 GMT

but if you have multiple dimension it might not work properly !!

Re: How to show only max date values?

Mon, 15 Jun 2015 10:35:29 GMT

Thanks. would it work if use in script? please let me know

Re: How to show only max date values?

MarcoWedel — Mon, 15 Jun 2015 10:37:05 GMT

Hi,

one solution could be:

expression:

=Timestamp(Max(date),'DD/MM/YYYY hh:mm')

If you also want to show the corresponding From-value, you could use the expression

=FirstSortedValue(From, -date)

hope this helps

regards

Marco