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 attached an example of what I am trying to do. Basically, I would like to pick up the max date in my dimension within a pivot table to display, but don't want to change the expression totals.
I would like my pivot to be displayed as:
Help is much appreciated.
Use as a measure.
View solution in original post
Thank you for coming back to me.
What do you mean by use first expression? You mean create a calculated dimension or use set analysis in my expression?
I use Qlikview, for some reason when I create a calculated dimension, Date(max(Date)); it is giving me a calculation error, even thought there are no errors.
This is what I am getting:
Happy Days, thank you. It would be nice to see if there is a way to do it within the dimension as well.
In that case, you have to make some changes at script level.
Tab:Load * Inline[Product,Date,AmountA,31/01/2019,100A,28/02/2019,200];
Test:NoConcatenateLoadProduct,Date(Max(Date)) as NewDateResident TabGroup by Product;