Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Get Previous Values

Hi Everyone,

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 chartSample Data.PNG

Thank's in Advance

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Get Previous Values

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.

PREVIOUS_DATA:

Load

'Q'&num(SubField(Quarter,'Q',2)+1) &'-'&DIM1&'-'&DIM2&'-'&DIM3    as Key_quarter,

Sum(PRIMES) as PrevPRIMES

resident MyTable

Group by Quarter,DIM1,DIM2,DIM3;

It worked perfectly.

Thank's Again.

13 Replies
vishsaggi
Esteemed Contributor III

Re: Get Previous Values

Try this in your Straight table expr

= IF(RowNo(TOTAL) = 1 OR RowNo(TOTAL) =2, 0, Above(TOTAL Sum(Value),2))

eduardo_dimperio
Valued Contributor II

Re: Get Previous Values

SCRIPT:

LOAD

VALUE

PEEK(VALUES) AS PREVIOS VALUE

RESIDENT YOURTABLE

ORDER BY

ASC VALUE;

Partner
Partner

Re: Get Previous Values

Hello,

Thank you for your reply

This is the result i get when applying your formula.Result.PNG

Note please that in my final Table i won't need the Quarter anymore.

Thank you very much

vishsaggi
Esteemed Contributor III

Re: Get Previous Values

Ok, is that not your expected output? if not what should be your expected output please let us know.

Partner
Partner

Re: Get Previous Values

Actually the Expected Result is:

 

QuarterDIM1DIM2DIM3PRIMESPrev
Q1D1DD1DD110
Q2D1DD1DD22010
Q3D1DD1DD33020
Q4D1DD1DD46030
Q1D2DD2DD5100
Q2D2DD2DD6200100
Q3D2DD2DD7300200
Q4D2DD2DD8400300

Thank you

Re: Get Previous Values

Can you do this?

Aggr(Above(Sum(PRIMES)), DIM1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
delroekid
Contributor

Re: Get Previous Values

try this on your Previous Field expression in straight table..

aggr(above( aggr(PRIMES,DIM1,Quarter)),DIM1,Quarter)

qv.JPG

MVP
MVP

Re: Get Previous Values

How about this:

LOAD Quarter,

     DIM1,

     DIM2,

     DIM3,

     PRIMES,

     If(AutoNumberHash256(DIM1, DIM2, DIM3)

          = Previous(AutoNumberHash256(DIM1, DIM2, DIM3)),

          Previous(PRIMES)

     ) as Prev

FROM  ....

ORDER BY DIM1, DIM2, DIM3, Quarter

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
delroekid
Contributor

Re: Get Previous Values

qv.JPG

aggr(above( aggr(PRIMES,DIM1,Quarter)),DIM1,Quarter)