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 a field year contains 2011,2012,2013 and month filter jan,feb,mar etc
i need to calculate the difference sales between current selected year month and previous month.(ie)
if i selected year 2011 then feb month then the result should find difference between jan and feb.....
pls,help me out thanks in advance.
Im looking for Sales diffrance eg if select year 2011 and month Jan and Feb.then sales diffrance will be Jan(sales)-Feb(sales)
So are you saying you'll always select exactly two months and that too consecutive months?
will do exactly as you described
It looks good but when i added my experssion part its not working.can pls upload sample app.
No.Any range selected month or year.just like Select CY Month sales- CP Month sales
sum (Feb(sales)-Jan(sales)) as diffrance between two month for selected Year
Thanks .my mistake missed some filed,If i select range of two month its showing properly diffrance .but im looking it should do calculate if not selected also.
Year selected (if not selected year it should be shown for month on month diffrance for all the Year)
Jan-Feb dif | Feb-Mar dif so on in pivot table(ie Jan sales is 200- feb sales 100)
Jan-Feb dif | Feb-Mar dif so on in pivot table
i like the way you done it might usefull to me in future analysis.i wll upload some sample app by today evening so you understand well thanks for try.