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.
Anybody can help me, how to get what Date and Max Value in Month?
I just want to get Max Tot_Trans in a month and what the date of that Max Value in a month
Date Year_Month Tot_Trans
31/1/2017 2017/01 19,084,195.00
28/2/2017 2017/02 22,483,191.00
Date is t
Thanks A lot
View solution in original post
If Tot_Trans is an expression, then may be this
FirstSortedValue(DATE - Aggr(Sum(Tot_Trans), DATE, YEAR_MONTH))
Max(Aggr(Sum(Tot_Trans), DATE, YEAR_MONTH))
Is it Possible to have it in Qliksense?
Thanks a lot
There is an error with this expressions :
- Error in expression : FirstSortedValue Takes 2-3 parameters
add a comma
FirstSortedValue(DATE ,-aggr(sum([Sum(TOT_TRANS)]), DATE, YEAR_MONTH))
Thanks for your help