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 want to use aggr() function to get total once for each key. The total is correct for each key, but they are not in the right position in a pivot table
I attached a test qvw.Could anyone help with that? thanks.
Add the nodistinct qualifier to the aggr function. See attached example.
View solution in original post
Looks like this one works:
It was getting sorted using date.
Changed the sort priority to be sorted using Key and then your 2nd expression value.
See if it helps.
Thanks for reply. It works in the test app. But when I use the formula in my real app, it fails. I attached my real app. Please take a look. Many thanks.
Thanks G and all of you.