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.

[robert_mika]

Could you share your data/screenshot/app?

[tamilarasu]

Hi Robert,

FYI: "GM Lost" is derived from those two subtotal columns.

[robert_mika]

I meant your Qlik chart screenshot..

[jagan]

Hi,

If you share the sample file that would be easier to solve this issue.  You can scramble the contents if it is confidential in the Qlikview file.

Regards,

Jagan.

[robert_mika]

Maybe I'm wrong but is it not the line fetching from your Excel file?

I see 0 in AU,AX and AY column but not sure what in the previous one.

You can delete the line in your Excel (simply way)(or you can add WHERE clause into your load statement)

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[tamilarasu]

Hi Jagan,

You can check the scrambled file in the attachment.

Hi Robert,

The above three columns are expressions. Though, I will check the script now. !

[robert_mika]

I'm on PE so I can not open your file but I have mentioned your first screenshot(Excel)

[hariprasadqv]

Hi,

Apply suppress null values property.

Thanks

[tamilarasu]

I have modified the load script but still getting the extra line.