Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

null values

Hi,

i am having raw data as below..

 

Feild1Feild2feild3
A1020
B6040
C
D

when i created the Pivot table, i can able to see only first two rows(A,B), remaining two rows are suppressed due to they are not containing values .

i want to see the C,D rows also if they do not have any values.

please help me on this.

12 Replies
Anonymous
Not applicable
Author

Under Dimension Tab of Chart,

Dimension - > Uncheck Suppress when value is null and Check Show All Value

anlonghi2
Creator II
Creator II

Hi Sowmya,

unselect "Suppress when value is null" for Field1 field from option from tab "Dimensions"

Best regards

Andrea

Anonymous
Not applicable
Author

see the attachment

Not applicable
Author

Hi Balraj,

thank you for the quick reply,

ya i have done that but still it is not showing te remaining rows.

it is showing the null values which are in A,B rows... not showing C,D rows..

any other help?

Not applicable
Author

Hi,

Select Chart>>Properties>>Dimension>>Tick on "Show All Values" option.

and Deselect "Suppress When Value is NULL" option.

I think that should solve your problem.

Regards,

KC

Not applicable
Author

Hi Anlon,

thank you for the quick reply,

ya i have done that already,but it is not showing the remaining rows.

it is showing the null values which are in A,B rows... not showing C,D rows..

like....

 

Feild1Feild2feild3feild4feild5
A1020100
B6040020
C
D

any other help?

Siva_Sankar
Master II
Master II

find the attached file

Not applicable
Author

Hi,

Select Chart >>Presentation >>Uncheck  'Suppress Zero-Value' Option.

Anonymous
Not applicable
Author

May be useful this link ...

NULL handling in QlikView

Bye Angelo