Pivot Calculated Dimension

Thu, 28 Feb 2013 16:25:36 GMT

Hi,

Im trying to show to different fields as a dimension in a pivot table by using the following expression :

=if(match([Indicator Name],'Type 1','Typ2'),[Filter 1], [Filter2])

If the first columns value is either Type1 or Type 2, then the next dimension should hold 'Filter 1' data otherwise is should how 'Filter 2' data. Is this possible to do?

Thanks,

Fiorano

Re: Pivot Calculated Dimension

Thu, 28 Feb 2013 16:29:06 GMT

the match() function assigns a value of 1 to 'Type1' and 2 to 'Typ2' as you have it written; it isn't a true/false operator.

I would try:

if([Indicator Name]='Type1' or [Indicator Name]='Typ2',[Filter 1], [Filter2]). But no promises.

topic Pivot Calculated Dimension in QlikView

Pivot Calculated Dimension

Re: Pivot Calculated Dimension