Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show all non numeric dimension values

Hi All,i am creating a bar chart with dimension registrant type and expression number of registrants.i want to show all the registrant types even if there is no registrant for a registrant type. How to do this?i tried show all values,unchecking supress zero values, missing values etc.i
5 Replies
Not applicable
Author

Hi,

Please find attached qvw. This is the way I have done it in tha past.

You need to add an expression as 1. and go to Presentation tab and hide the column.

for bar chart, uncheck bar in display option

Thanks

Not applicable
Author

Hi,

I have 2 expressions . Adding 1 didnt help me

Anonymous
Not applicable
Author

parabgautam has answered your initial question the way it reads.  Maybe you could provide a sample for a closer look.

v_iyyappan
Specialist
Specialist

Hi,

     I attached sample QV file. I think u expect this concept. hope its helpful for u.

Regards,

Iyyappan.

Anonymous
Not applicable
Author

Adding a 1 didn't help you in your current example because your second expression was always going to be 1.

You could set your second expression to invisible, like parabgautam suggests.  This will hide your Count(Desc) but still use it to display the Type label on your X-Axis.