Remove empty values in a line chart

Wed, 14 Sep 2011 20:39:33 GMT

Hello

I am trying to hide the lines in the line chart where the values are equal= 0. I had no problem doing this in a straight table. I just added C_ACT2<>0 in the presentation tab under conditional columns, but I don't know how to to do it in the line chart.

For example:(in the below picture)

I have C_ACT2 and C_ACT2_BASE they don't actually appear in the line chart but they are assigned a color by default. Can I remove them from the list, since their value is 0?

All the values that are 0 are removed from the Straight table. Therefore, the values shown in the straight table are the same that should be shown in the line chart.

Any suggestions on how to do this?

Thanks in advance

Remove empty values in a line chart

Wed, 14 Sep 2011 21:04:37 GMT

Hi,

In your expressions for C_ACT2 and C_ACT2_BASE you have to use an IF like this:

if(sum(Sales) > 0 , sum(Sales), '')

Hope this helps

Regards!

Remove empty values in a line chart

Wed, 14 Sep 2011 21:12:42 GMT

Thanks Gabriela

That solved my issue.

topic Remove empty values in a line chart in QlikView

Remove empty values in a line chart

Remove empty values in a line chart

Remove empty values in a line chart