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.
Here I have some problem in my pivot table dimension.
I want to remove last n months form sale month dimension in pivot table
If months are more than 12 ,so Sale Year should be remove.
please find attach image for more clarity.
thanks in advance.
nData = numeric date
View solution in original post
What exactly are you trying to remove? Can you elaborate what the result needs to look like?
hi sunny ,
sorry I attached wrong attachment ,
in my pivot table I am showing sell out where I want to remove n sale months sale out details from pivot table.
ex- I have one filter MIS have values 3,6,12 and 24
If I select 3 in MIS last three sale (From Current month) months Sell out should not come.
This expression really helpful to make right one.