topic Re: Help On Pivot Chart in QlikView

Help On Pivot Chart

VishalWaghole — Fri, 23 Aug 2013 18:26:46 GMT

Hi Community,

I have pivot table output.

Pivot table have two dimension and two expression.

Dimension called as Category have some null values but i dnt want to show that null values.

so please help me regarding my this problem.

I have attached here sample QVW and Excel file.

Thanks and Regards,

Vishal

Re: Help On Pivot Chart

mphekin12 — Fri, 23 Aug 2013 18:32:12 GMT

In the Dimensions tab select the Category dimension then click the Suppress When Value Is Null checkbox in the Setting for Selected Dimension area.

Re: Help On Pivot Chart

VishalWaghole — Sat, 24 Aug 2013 04:57:33 GMT

Hi,

Thanks for your reply, i already did it but if i enable that check box then

my other null values which are belong to Type field also gets to hide.

I want to hide only null values which are belongs to Category Fields.

Thanks

Re: Re: Help On Pivot Chart

Sat, 24 Aug 2013 05:12:08 GMT

Hi,

If you want to suppress null value in category then that will affect the type too. If you don't want to suppress the type then you can map null value in the category as unknown. Please find the attached file. I hopes it helps you

Thanks and Regards,

S.Amuthabharathi.

Re: Help On Pivot Chart

rajeshvaswani77 — Sat, 24 Aug 2013 05:12:50 GMT

Hi Vishal,

In your QVW CEQ REVISED MAJOR field has major when it is major and null when it is not major.

you would have to change

[Revised Major] as [CEQ REVISED MAJOR],

if([Revised Major]='Major',Major','Minor') as [CEQ REVISED MAJOR],

thanks,

-RV

Re: Help On Pivot Chart

Gysbert_Wassenaar — Sat, 24 Aug 2013 12:22:16 GMT

As Rajesh says it's best to replace the nulls in the [Revised Major] field with real values. You can do this with for example:

alt([Revised Major],'_missing_') as [CEQ REVISED MAJOR],

This will replace nulls with the string value _missing_. You can then change the Raised expression to:

Count({<[CEQ REVISED MAJOR]-={'_missing_'}>} ID_KEY)

This will count ID_KEY's where the value of CEQ REVISED MAJOR is not the value _missing_.