Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

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

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.

Re: query to calculate diff between 2 month data

Here you go

Capture.PNG

amita1621
New Contributor II

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