topic Re: Max date in dimension in a piro table in QlikView

Max date in dimension in a piro table

Mon, 26 Jan 2026 16:26:21 GMT

hallo everybody,

I need your help for a set dimension in a dimension. I need the last date for a special criteria as dimension.

I use the max function but this doesnot work.

Can anybody help me.

One sample for my formula:

if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE))

Thanks and greetings Sven

Nicole-Smith — Tue, 26 Nov 2013 16:24:28 GMT

if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE' and INVT_TRANS_DETAIL.TRAN_DATE=$(=max(INVT_TRANS_DETAIL.TRAN_DATE)), INVT_TRANS_DETAIL.TRAN_DATE)

tresB — Tue, 26 Nov 2013 16:48:15 GMT

May be like:

Aggr(if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE)) , INVT_TRANS_DETAIL.TRAN_CODE)

Or,

Aggr (Max({<NVT_TRANS_DETAIL.TRAN_CODE={'SPRECEIVE'}>}INVT_TRANS_DETAIL.TRAN_DATE),INVT_TRANS_DETAIL.TRAN_CODE)

Note: Aggr() might not be required if you want the result in a text box

Wed, 27 Nov 2013 10:49:00 GMT

thanks for your answer, but this formula does not work for my pirotable

Nicole-Smith — Wed, 27 Nov 2013 14:17:34 GMT

Can you post an example .qvw? It's almost impossible to help without one.