This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have written below expression in calculated dimension to get max month year but getting all months in dimension.
Please do the needful.
Try to use?
It is giving max month year but not get correct values for maximum month
=aggr(max(monthyear),monthyear) will aggregated for every monthyear and calculating the max(monthyear), so that´s correct retrieving all monthyear
It is showing error in calculated dimension message if i am giving max(monthyear)
Max() won't work in calculated instead why can't you write in expression and promote them to dimension place?
It should even work without aggr(), like max( TOTAL monthyear) . If your monthyear is a dual field, this expression should work; you might want to format it like = monthname(max(total monthyear))
Yes It is giving max monthyear if i used total word but my expression values is coming total values instead of max month values