topic Re: Re: find difference in Pivot table in QlikView

find difference in Pivot table

Anonymous — Thu, 24 Oct 2013 18:22:12 GMT

Hi guys,

I have a pivot table

I want to calculate difference between the same tag from previous period.

Other words: Check pricing Sep 2013 31%-Check pricing Aug 2013 27% = dif 4% and so on.

When I use above or below, it calculates for Sep 2013 31%-3%=28%; 3%-48%=-45% and so on in one current month.

But I'd like compare the same but with previous period.

Please see the attached file.

Thanks,

Re: find difference in Pivot table

swuehl — Thu, 24 Oct 2013 18:27:40 GMT

Your idea using chart inter record functions is good, you just need to add advanced aggregation to tell QV the correct dimension order.

Check attached.

Re: find difference in Pivot table

MayilVahanan — Thu, 24 Oct 2013 18:59:17 GMT

Try like this

Alt(aggr(

Count({<[qID_2_Primary purpose of visit]={'Learn about services','Check pricing','Purchase Vonage services','Find promotion info','Buy Vonage services','Other'}>}POV)/Count(TOTAL <MYear> POV)

above(

Count({<[qID_2_Primary purpose of visit]={'Learn about services','Check pricing','Purchase Vonage services','Find promotion info','Buy Vonage services','Other'}>}POV)/Count(TOTAL <MYear> POV)

)

,POV,MYear),0)

Re: Re: find difference in Pivot table

Anonymous — Thu, 24 Oct 2013 19:18:05 GMT

Thanks for suggestion

My original expression is bigger.

It works, when I switch dimensions (instead of Above, I use before)

I can't switch dimensions in my chart.

Please see my file.

Re: Re: find difference in Pivot table

Anonymous — Thu, 24 Oct 2013 19:18:34 GMT

Thanks for suggestion

My original expression is bigger.

It works, when I switch dimensions (instead of Above, I use before)

I can't switch dimensions in my chart.

Please see my file.

Re: Re: Re: find difference in Pivot table

swuehl — Thu, 24 Oct 2013 21:44:43 GMT

Why not? Please check attached

Re: find difference in Pivot table

Anonymous — Fri, 25 Oct 2013 14:06:30 GMT

Thanks. You're awesome