Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

amita1621
New Contributor II

query to calculate diff between 2 month data

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??

1 Solution

Accepted Solutions
MVP
MVP

Re: query to calculate diff between 2 month data

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

13 Replies
MVP
MVP

Re: query to calculate diff between 2 month data

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

amita1621
New Contributor II

Re: query to calculate diff between 2 month data

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

MVP
MVP

Re: query to calculate diff between 2 month data

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

Capture.PNG

amita1621
New Contributor II

Re: query to calculate diff between 2 month data

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
New Contributor II

Re: query to calculate diff between 2 month data

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

MVP
MVP

Re: query to calculate diff between 2 month data

Here you go

Capture.PNG

Highlighted
amita1621
New Contributor II

Re: query to calculate diff between 2 month data

Can you explain

Dim:

LOAD * INLINE [

    Dim

    1

    2

];

MVP
MVP

Re: query to calculate diff between 2 month data

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

MVP
MVP

Re: query to calculate diff between 2 month data