Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

mhmhmh91
New Contributor

Only display a dimension value in a specific date

Hi,

I have encountered a problem. I have a table like below,

ItemTypeActionQtyReportDate
Aabcaaa10009/11/2017
Acdeaaa20008/31/2017
Bccccaabb40009/11/2017
Bccccddee30008/31/2017

I only want to display rows with max ReportDate in a table. like:

ItemTypeActionQtyReportDate
Aabcaaa10009/11/2017
Bccccaabb40009/11/2017

ReportDate is dynamic, Type and Action are character values, so I don't know how to restrict them to a specific date with set analysis when adding them as measures or if statement when adding them as dimension,

Thank you,

Mandi

1 Reply
YoussefBelloum
Esteemed Contributor

Re: Only display a dimension value in a specific date

Hi,

"Report Date" is a dimension so keep it as a dimension and try this on the Quantity expression:

=sum({<date={"$(=date(Max(date)))"}>}Qty)

it should display just the lines with max dates.

Regards,

Youssef

Community Browser