Discussion Board for collaboration related to QlikView App Development.
I have this data
I want to do a cross table to have the value of the last date per month.
But of course i don't have this value by month, only the max date 😞. In my table I have only
In a cross table , how to have the max date value BY MONTH please ?
Thank you for your help and time
test the max date in your dimension instead of the expression:create a calculated dimension:
=if(date(aggr(nodistinct max(Date),Month)) = Date, Date)
in your expression
View solution in original post
the dimension will return the Date if it is equal to the maximum date else null, so set suppress when null
It works perfectly.
Thank you very very much for your help.
So I try to understand.
In my dimension, I choose only the last day of each month by the aggr
And It picks the date that is equal to one of these dates.
yes that is correct, it will cycle through all the dates and any date that is equal to any of the aggregation results will have a value, others will have null. that is why you need to set suppression on the nulls.