topic Re: query to calculate diff between 2 month data in QlikView

query to calculate diff between 2 month data

amita1621 — Thu, 12 Apr 2018 11:07:12 GMT

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

Re: query to calculate diff between 2 month data

sunny_talwar — Thu, 12 Apr 2018 11:26:30 GMT

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

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 06:14:58 GMT

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

sunny_talwar — Mon, 16 Apr 2018 08:53:52 GMT

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

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 09:17:58 GMT

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.

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 09:19:10 GMT

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

Re: query to calculate diff between 2 month data

sunny_talwar — Mon, 16 Apr 2018 11:49:43 GMT

Here you go

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 12:09:14 GMT

Can you explain

Dim:

LOAD * INLINE [

Dim

];

Re: query to calculate diff between 2 month data

sunny_talwar — Mon, 16 Apr 2018 12:10:05 GMT

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

Re: query to calculate diff between 2 month data

sunny_talwar — Mon, 16 Apr 2018 12:11:26 GMT

Here you might find some other examples

Pivot Table Partial Percentage

Percent of Total in Pivot Table

Pivot table issue help

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 13:09:51 GMT

Please see the attached QV file. i am getting % for each band , how can i have the total change at the end, same as above excel attcahed

Re: query to calculate diff between 2 month data

sunny_talwar — Mon, 16 Apr 2018 13:10:29 GMT

Amita, would you be able to share a more representative sample to help you better

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 13:15:10 GMT

yes sure thanks

Re: query to calculate diff between 2 month data

amita1621 — Mon, 16 Apr 2018 13:27:11 GMT

Sorry to bother so many times.

Please check the qlikview file i created and now i need % change at the last based on Month