topic To change the expression label in Pivot Table in QlikView

To change the expression label in Pivot Table

thirumalaivadiv — Tue, 16 Feb 2016 13:36:08 GMT

Hi Team

I want to change the expression label dynamically in pivot table pls help.

Required output will be if LifePro then Disability claim if Lawson Disability Claim Lawson and if difference Difference resply for other columns as well

Thanks

Thiru

Re: To change the expression label in Pivot Table

Mark_Little — Tue, 16 Feb 2016 14:25:25 GMT

Hi,

In your label you would need to use something like

=If(Field='LifePro', 'Disability claim', IF(...))

But this would only work if you are getting a single value here. Also field would be the field in your data your are comparing

Mark