topic Re: Line Chart: hide null dimension from expression. in QlikView

Line Chart: hide null dimension from expression.

Thu, 01 Dec 2016 08:52:09 GMT

Hi,

Is it possible to hide Null dimension from legend but include values in expression?

Example:

Project	Project Type	Revenue	Period
project 1		100	01/2016
project 1		100	02/2016
project 2	A	200	02/2016
project 3		300	03/2016
project 4	B	400	03/2016
project 4	B	400	04/2016

My chart has two dimensions: Period and cyclic group with Project and Project Type as dimensions. So you can view revenue over period by project type and project. Since all projects do not have Project Type, you will have null value in legend. However, requirement is that when there is no value in project type only Total is to be shown. And when there is value, Project Type in addition to Total is to be shown.

This is easily done with three expressions and set analysis but then I cannot use cyclic dimension. Does anyone know if there is a way to solve this?

Re: Line Chart: hide null dimension from expression.

MK_QSL — Thu, 01 Dec 2016 08:59:33 GMT

You mean to say two dimensions

1) Period

2) Cyclic Group (i.e Project , Project Type)

Re: Line Chart: hide null dimension from expression.

sunny_talwar — Thu, 01 Dec 2016 09:08:55 GMT

Would you be able to show how the expected output needs to look like or better, can you share a sample?

Re: Line Chart: hide null dimension from expression.

Thu, 01 Dec 2016 09:59:47 GMT

Hi, I added an example on what I currently have and what I am trying to achieve.

Basically what I need is to hide Null value from legend but include values from null rows in expression result.

Re: Line Chart: hide null dimension from expression.

sunny_talwar — Thu, 01 Dec 2016 10:21:50 GMT

See if you like the attached. I had to use some work around (for instance use a button with an image of cycle group instead of the actual cycle group)