query to calculate diff between 2 month data

[amita1621]

I have attached a file for the  reference i have  created the file with current and prev month data by using pivot in qlikview, now how can i calculate % change from Prior Month.

COuld you please help??

[sunny_talwar · Accepted solution]

Would you be able to share a qvw sample to look at what are the dimensions and what are the expressions

[amita1621]

PFA the sample QVW file for reference . I need  a next column which shows % diff between 2 amounts (Jan- Feb).

[sunny_talwar]

there is only d2 where you have a value in both jan and feb month... are you hoping to get 150% for d2?

[amita1621]

Have you seen the excel screenshot attached . I want qlikview in that format, these are random values hi have taken in test qvw file.

I want Feb all values by band then jan then the percenatge by band.

[amita1621]

Please see attached excel i want qlikview graph in this format.

[sunny_talwar]

Here you go

[amita1621]

Can you explain

Dim:

LOAD * INLINE [

    Dim

    1

    2

];

[sunny_talwar]

Just an island table used to create the view your are looking to get

[sunny_talwar]

Here you might find some other examples

Pivot Table Partial Percentage

Percent of Total in Pivot Table

Pivot table issue help