topic Pivot Problem in QlikView

Pivot Problem

vijayit43 — Tue, 14 Oct 2014 13:40:18 GMT

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.

Re: Pivot Problem

ashfaq_haseeb — Tue, 14 Oct 2014 13:46:57 GMT

Like this.

Regards

ASHFAQ

Re: Pivot Problem

Tue, 14 Oct 2014 13:53:27 GMT

Hi Ashifaq,

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

Re: Pivot Problem

sivarajs — Tue, 14 Oct 2014 13:58:16 GMT

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 - ).

Re: Pivot Problem

vijayit43 — Tue, 14 Oct 2014 13:58:18 GMT

how to achieve it

Re: Re: Pivot Problem

ashfaq_haseeb — Tue, 14 Oct 2014 13:59:28 GMT

Check this

Re: Pivot Problem

Tue, 14 Oct 2014 14:03:48 GMT

Hi Ashfaq,

Thanks