topic Re: Need Help..? in QlikView

Need Help..?

Nagaraju_KCS — Tue, 11 Mar 2014 16:40:37 GMT

Hi All,

I have a Pivot table having null data. how to remove only column not row's.

if i am check the Suppress Null Values hiding all Zero columns and rows..

but i required all Division's.....

PFA,

Thanks in Advance..........

Re: Need Help..?

Nagaraju_KCS — Tue, 11 Mar 2014 16:50:47 GMT

Hi Designing Experts,

Anyone face this type of problem...............???????

Re: Need Help..?

its_anandrjs — Tue, 11 Mar 2014 16:52:11 GMT

Hi,

If you select Suppress When Value is null then Null columns and rows removed but you are not able to see zero column and rows also all division which are zero not shown.

Thanks & Regards

Re: Need Help..?

Nagaraju_KCS — Tue, 11 Mar 2014 16:58:03 GMT

Hi Anand,

That's why am asking, but i need all Division with Zero values also..

But i am getting extra column..i want to hide that column only....

See the first Image....

Re: Need Help..?

Anonymous — Tue, 11 Mar 2014 17:10:02 GMT

yes you can set a condition in "dimension" tab to show or hide a specific column

Re: Need Help..?

Tue, 11 Mar 2014 17:48:22 GMT

HI,

I believe its not possible to meet your exact requirement. I am eager to see if someone can crack this.

Re: Need Help..?

Tue, 11 Mar 2014 18:21:28 GMT

try this on your script:

TEST:

LOAD Division,

if(isnull(Plant),'No data',Plant) as Plant,

if(isnull(Plant),0,OrderQty) as OrderQty

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);