topic Re: set analisys max(date) filter in QlikView

set analisys max(date) filter

dcd123456 — Sat, 16 Nov 2024 04:01:03 GMT

Hello

i have a table with three fields like this

idc	my_stamp_date	vaue
2850	29/03/2019 06:41:19	20,37
2850	29/03/2019 06:41:29	20,33
2850	29/03/2019 06:41:39	20,31
2849	29/03/2019 06:43:29	21,51
2849	29/03/2019 06:43:39	21,53
2849	29/03/2019 06:43:49	21,53
2849	29/03/2019 06:49:29	21,64
2769	29/03/2019 06:41:21	21,2
2769	29/03/2019 06:41:30	21,05
2769	29/03/2019 06:41:41	20,89

i need to show a straigh table with the idc field as dimension, to show the value field that correspond to the max of the field my_stamp_date for each idc value, for example with the abobe data i need to show the next result


idc	my_stamp_date	vaue
2850	29/03/2019 06:41:19	20,37
2849	29/03/2019 06:43:29	21,51
2769	29/03/2019 06:41:21	21,2

i have defined a strigh table with the field idc as dimension and the next expresion:

only({<my_stamp_date= {"$(=Max(my_stamp_date))"}>} value)

but don't work, it only show me the value that correspondt to the global max value of the field my_stamp_date it seem

idc	my_stamp_date	vaue
2849	29/03/2019 06:43:29	21,51

it seem that translate the expresion to only({<my_stamp_date= {"29/03/2019 06:43:29"}>} value) and only show me a record, no the value of the max my_stamp_date of each group of idc.

Thanks in advance for your help

best regards

diego

Re: set analisys max(date) filter

tresB — Fri, 29 Mar 2019 06:33:08 GMT

Set analysis gets evaluated once per chart; and not row-wise. Try like:

Dim: idc

Exp1 (max date): timestamp(max(my_stamp_date))

Exp2 (max date value): firstsortedvalue( vaue, - my_stamp_date)

Re: set analisys max(date) filter

amrinder — Fri, 29 Mar 2019 07:16:47 GMT

Handle it at script level using FirstSortedValue function.

-amrinder

Re: set analisys max(date) filter

VishalWaghole — Fri, 29 Mar 2019 07:36:54 GMT

Use this,

have look at attached document

Dim : idc
Calculated Dim : Timestamp(aggr(min(my_stamp_date),idc),'DD/MM/YYYY hh:mm:ss')
Expression for vaue : FirstSortedValue(vaue,-aggr(min(my_stamp_date),idc))

To achieve this make sure your date fields should display in Timestamp formate at qlik level.

Thank
Vishal Waghole