Testing Pivot Dimension

Thu, 20 Mar 2014 10:50:14 GMT

Hi,

I have a 'Target' dimension within my pivot which is a numeric value.

Depending on the ID number of the 'row' I need to replace this numeric Target with some text :

=if(match([ID],82,114,558),'Monitor',Target)

which works fine.

The only issue I have is some ID's have blank 'Target' values and because I have the following pivot settings to show Null values as 0 :

Any null Target values are showing as 0. Can the expression be altered to show a blank space where the Target value is null - but I still need my Pivot calculated values to show 0 rather than null??

Many thanks for you help!!

Re: Testing Pivot Dimension

Thu, 20 Mar 2014 10:56:35 GMT

Modify the expression of the Target:

=if(match([ID],82,114,558),'Monitor',

if(not isnull(Target),Target,'SomeText'))

topic Re: Testing Pivot Dimension in QlikView

Testing Pivot Dimension

Re: Testing Pivot Dimension