topic Re: How to show all non numeric dimension values in QlikView

How to show all non numeric dimension values

Thu, 23 Feb 2012 22:31:54 GMT

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

Re: How to show all non numeric dimension values

Thu, 23 Feb 2012 22:38:44 GMT

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

Re: How to show all non numeric dimension values

Thu, 23 Feb 2012 22:50:45 GMT

Hi,

I have 2 expressions . Adding 1 didnt help me

How to show all non numeric dimension values

Anonymous — Fri, 24 Feb 2012 03:00:53 GMT

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

Re: How to show all non numeric dimension values

v_iyyappan — Fri, 24 Feb 2012 05:20:07 GMT

Hi,

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

Regards,

Iyyappan.

Re: How to show all non numeric dimension values

Anonymous — Fri, 24 Feb 2012 05:25:56 GMT

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.