Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

amita1621
New Contributor III

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
Highlighted

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
Highlighted

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 III

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).

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 III

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 III

Re: query to calculate diff between 2 month data

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

Re: query to calculate diff between 2 month data

Here you go

Capture.PNG

amita1621
New Contributor III

Re: query to calculate diff between 2 month data

Can you explain

Dim:

LOAD * INLINE [

    Dim

    1

    2

];

Re: query to calculate diff between 2 month data

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

Re: query to calculate diff between 2 month data

Community Browser