topic Re: Hardcoded pivot table into a dynamic pivot table in QlikView

Hardcoded pivot table into a dynamic pivot table

Wed, 02 Apr 2014 05:59:54 GMT

Chaps, I had a pivot table where all the expressions were hardcoded, which means after every load we had to adjust the expressions. I am in the process of making that a dynamic pivot table. I have achieved 50%. I have got the basic expression right, but now I want to arrive at the change and the change % dynamically. I think I should use Column(2)-Column(1) in a dynamic fashion. Is there a method to get the current column position in terms of the expression. Something like Column(currentcolumn) - Column(currentcolumn-1), which will be helpful to me.

Also in this case there is just one expression. So I don't think Column() function will work.

Please find attached the screenshots, that should give you an idea of what I actually want to achieve.

Thanks,

Ram

Re: Hardcoded pivot table into a dynamic pivot table

MK_QSL — Wed, 02 Apr 2014 06:01:23 GMT

Hi, Can you please provide sample data?

Re: Hardcoded pivot table into a dynamic pivot table

nizamsha — Wed, 02 Apr 2014 06:06:57 GMT

if ur expression is right in both the column mean u can do that column(2)- column(1)

or u can give the label name- label name

Re: Hardcoded pivot table into a dynamic pivot table

Wed, 02 Apr 2014 06:14:34 GMT

no Nizam, there is just one expression. So cannot use column() function.

Re: Hardcoded pivot table into a dynamic pivot table

Wed, 02 Apr 2014 06:15:10 GMT

actually I thought above(sum(<expr>),'Period',-1) would have been more appropriate, but that didn't work.

Re: Hardcoded pivot table into a dynamic pivot table

Wed, 02 Apr 2014 06:18:43 GMT

can be something like this

PeriodCode Count

Feb2014 1000

Sep2013 2000

Jun2013 1500

Mar2013 600

Re: Re: Hardcoded pivot table into a dynamic pivot table

Wed, 02 Apr 2014 06:24:27 GMT

if my actual expression is

sum([Employee Count])

can't I say

sum([Employee Count)

above(sum([Employee Count],'Period',-1))

won't that work?