topic Pivot table Query in QlikView

Pivot table Query

Mon, 10 May 2010 11:01:03 GMT

Hi,

In a Pivot table... wherever there is a zero I want to replace it with blank.

Is it possible and if yes then how??

Regards

Pivot table Query

Mon, 10 May 2010 11:12:09 GMT

Hi Rohita,

This is possible. If you want to replace zeros by a null(blank spaces are known as null), you just need to write a chart expression. The expression is like this.

if(field=0,' ',fieldvalue)

in this expression field represents that field which you want to check where there are any 0's in it. if you give this expression in your chart then I hope your problem will be solved. hope this helps you...

Thanks and regards

Joseph

Pivot table Query

Mon, 10 May 2010 11:35:16 GMT

Thanks a lot Joseph 🙂

It worked!!