Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max date in dimension in a piro table


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

4 Replies
Nicole-Smith

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

tresesco
MVP
MVP

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

Not applicable
Author

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

Nicole-Smith

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