topic Re: Pivot Table in QlikView

Pivot Table

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have one pivot table having 2 dimensions i.e year and code . now i need to hide the rows which are having no data for code dimension .

How i can solve it?

Thanks in advance..

Re: Pivot Table

vcanale — Wed, 09 Nov 2016 09:49:16 GMT

Hi,
Chart Properties, click on Code dimension and select Suppress When Value is Null:

Hope this will help

Re: Pivot Table

prabhas277 — Wed, 09 Nov 2016 09:51:47 GMT

i did that still some more rows are there

Re: Pivot Table

vcanale — Wed, 09 Nov 2016 09:52:53 GMT

Tried to select "Suppress Missing" in the tab Presentation?

Re: Pivot Table

vcanale — Wed, 09 Nov 2016 09:58:27 GMT

or you can try to add the dimension Code as a Calculated Dimension:
=if(Code<>'',Code)

Re: Pivot Table

prabhas277 — Wed, 09 Nov 2016 09:59:03 GMT

I checked that option also but still some more.

Is there any possible way to get that by using expression?

Re: Pivot Table

prabhas277 — Wed, 09 Nov 2016 10:03:19 GMT

if am using If (code<>",code) then i am getting error..

Re: Pivot Table

trdandamudi — Wed, 09 Nov 2016 10:03:58 GMT

In the dimension for the code you can use the below expression:

=if(Len(Code)>0, Code)

Note: Make sure you select "Suppress when value is null" in the dimension tab

Re: Pivot Table

vcanale — Wed, 09 Nov 2016 10:07:00 GMT

which error?
..could you please post it?

Re: Pivot Table

deepakkrish — Wed, 09 Nov 2016 10:11:49 GMT

Check "Suppress when value is null" to all fields in dimension tab,

at the same time check "Suppress zero values" in presentation tab for expression field.

check once

Re: Pivot Table

Wed, 09 Nov 2016 10:36:10 GMT

Hey Plz look into the attachments...!

Re: Pivot Table

nagarjuna_kotha — Wed, 09 Nov 2016 10:39:50 GMT

Hi Prabhas ,

Plz share sample file or data and expected output,for quick answer.

-Nagarjun

Re: Pivot Table

Anonymous — Wed, 09 Nov 2016 10:47:34 GMT

Hi,

I guess u dont need to change the dimension, u can go to settings for selected dimension and give enable conditional and give the same there . It will work i guess.

-Vigneshwaran M K