Extra line in chart

[tamilarasu]

Hi All,

In my application, I have a chart which contains of 65 columns and the chart was working fine 2 days before. Yesterday, I have added 7 extra columns from that I am getting extra line in the chat. I have checked and found that two columns (expression) showing 0. Because of that I am getting extra line. Both the columns contains nested IF statements. What could be the reason. ?

Thank you.

[tamilarasu]

Hi Hariprasadqv,

I have already checked this point. But getting extra line.

[MayilVahanan · Accepted solution]

Hi

Try like this

In Dimension tab,

check the "Suppress When Value is Null" check box.

Hope it helps

[tamilarasu]

Ok Thanks. I just want to know the reason for the extra line. It would be helpful.

[MayilVahanan]

Hi

May be its due to some mapping issue.

[Anonymous]

Hi I solved this problem by changing the action statement by removing the final else ' ' portion of the expression in the "Action" expression field. I also added a portion to the if condition to only calculate if there is a unique_field using "not isnull".

The new expression is as follows:-

If([Exclusion]='X' and not IsNull(Unique_Field),'',If(Match([Origin of Price before ZMAO or ZMAN],'ZFIX','ZTEN','ZNET'),'check current customer condition',IF([frequency in last 6 months]>1,IF([Total disc.]<40,

               'Load ZD on Material','Load ZF'))))

Then for the "Mel & MARA description" expression I added a if statement to ensure the expression is only calculated then there is a unique_field.

This not looks like this:-

if(not isnull(Unique_Field), Material &' - '&[Material description])

It worked in the example, let me know if it works for you

[robert_mika]

What if you delete the line from your Excel file?

[jagan]

or else don't load that column into Qlikview?

Regards,

Jagan.

[tamilarasu]

Thanks for the reply to both of you.

@Robert: Yes. But the end user don't want to see the line from chart itself.

@Jagan: Mentioned columns are expressions. I have a unique field in dimensions where I have marked "Suppress null values" option. I have 0's in the three columns, so the line suppressed automatically.