Pivot Problem

[vijayit43]

My Qlikview Dashboard Raw Data Like

Item	Site	Qty
Item 1	Site 1	4
Item 1	Site 2	0
Item 2	Site 1	6

and I want data in qlikview Like This Where 0 then show 0 when null then show blank.

Row Labels	Site 1	Site 2
Item 1	4	0
Item 2	6

how to achieve this please suggest.

[ashfaq_haseeb]

Like this.

Regards

ASHFAQ

[#3]

Hi Ashifaq,

Can you plz provide the code.i am unable to access this application right now.

[sivarajs · Accepted solution]

Drag the dimension site (blue arrow) over qty you will get the table structure you want. Then in presentation tab of chart properties remove null and missing symbol to blank(by default shows - ).

[vijayit43]

how to achieve it

[ashfaq_haseeb]

Check this

[#7]

Hi Ashfaq,

Thanks