Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: How to show all non numeric dimension values

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

Re: How to show all non numeric dimension values

Hi,

I have 2 expressions . Adding 1 didnt help me

janderson
Contributor

How to show all non numeric dimension values

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

v_iyyappan
Valued Contributor

Re: How to show all non numeric dimension values

Hi,

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

Regards,

Iyyappan.

janderson
Contributor

Re: How to show all non numeric dimension values

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.

Community Browser