rename the expression label in pivot table

willinek — Wed, 08 Sep 2010 14:19:03 GMT

Hi everybody,

i have a realy big problem here an no Idea how to solve it.

I have a pivot table, in which I drag the 2nd dimension to the top. As a result, I get 3 Columns, because my dimension (Values from a data island) always has just 3 values. Furthermore I have got 2 expression (IST and % V). My Problem now is, that I like to rename the expression IST to Plan only for the third value auf dimension 2. But I have no Idea how to accomplish that. Does anybody know how to do that?.

example:

how it is

--------------------------------------------------------------------
Area | Jan 2010 | Jan - Aug 2010 | Total2010 |
--------------------------------------------------------------------
|IST | % V | IST | % V |IST | %V |
------------------------------------------------------------------
V1 | 1 | 1% | 22 | 10% | 23 | 15% |
V2 | 2 | 1% | 23 | 10% | 21 | 14% |
V3 | 3 | 1% | 25 | 11% | 38 | 18% |

how it should be

--------------------------------------------------------------------
Area | Jan 2010 | Jan - Aug 2010 | Total2010 |
--------------------------------------------------------------------
|IST | % V | IST | % V |PLAN | %V |
------------------------------------------------------------------
V1 | 1 | 1% | 22 | 10% | 23 | 15% |
V2 | 2 | 1% | 23 | 10% | 21 | 14% |
V3 | 3 | 1% | 25 | 11% | 38 | 18% |

Thanks in advance

Alex

rename the expression label in pivot table

johnw — Wed, 08 Sep 2010 19:07:34 GMT

Perhaps this as your expression's label?

if(YourField='Total2010','PLAN','IST')

rename the expression label in pivot table

willinek — Thu, 09 Sep 2010 09:24:51 GMT

Hi John,

thanks for your help, but it is not that easy. I tried out different approches with the Columnno() and dimensionality() functions, but did not succeed at all.

Any other Ideas?

Thanks

Alex

topic rename the expression label in pivot table in QlikView

rename the expression label in pivot table

rename the expression label in pivot table

rename the expression label in pivot table