Help On Pivot Chart

[VishalWaghole]

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

[mphekin12]

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

[VishalWaghole]

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

[#4]

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.

[rajeshvaswani77]

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],

to

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

thanks,

-RV

[Gysbert_Wassenaar]

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