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 the sample data below and i would like to get the Previous Value Column,
For each Quarter, get the value of the previous one, either in the script or in the chart
Thank's in Advance
Thank you everyone for your reponses, but all the solutions provided are not working.
I have tried this solution, to get Previous Data in a separate table and join it to my original table using a new generated key and playing with the quarter number.
'Q'&num(SubField(Quarter,'Q',2)+1) &'-'&DIM1&'-'&DIM2&'-'&DIM3 as Key_quarter,
Sum(PRIMES) as PrevPRIMES
Group by Quarter,DIM1,DIM2,DIM3;
It worked perfectly.
View solution in original post
Try this in your Straight table expr
= IF(RowNo(TOTAL) = 1 OR RowNo(TOTAL) =2, 0, Above(TOTAL Sum(Value),2))
PEEK(VALUES) AS PREVIOS VALUE
Thank you for your reply
This is the result i get when applying your formula.
Note please that in my final Table i won't need the Quarter anymore.
Thank you very much
Ok, is that not your expected output? if not what should be your expected output please let us know.
Actually the Expected Result is:
Can you do this?
try this on your Previous Field expression in straight table..
How about this:
If(AutoNumberHash256(DIM1, DIM2, DIM3)
= Previous(AutoNumberHash256(DIM1, DIM2, DIM3)),
) as Prev
ORDER BY DIM1, DIM2, DIM3, Quarter