topic Re: Extra line in chart in QlikView

Extra line in chart

tamilarasu — Wed, 01 Jul 2015 05:08:50 GMT

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.

Re: Extra line in chart

robert_mika — Wed, 01 Jul 2015 05:18:07 GMT

Could you share your data/screenshot/app?

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 05:20:27 GMT

Hi Robert,

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

Re: Extra line in chart

robert_mika — Wed, 01 Jul 2015 05:24:42 GMT

I meant your Qlik chart screenshot..

Re: Extra line in chart

jagan — Wed, 01 Jul 2015 05:28:09 GMT

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.

Re: Extra line in chart

robert_mika — Wed, 01 Jul 2015 05:36:16 GMT

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)

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 05:43:27 GMT

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. !

Re: Extra line in chart

robert_mika — Wed, 01 Jul 2015 05:49:03 GMT

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

Re: Extra line in chart

hariprasadqv — Wed, 01 Jul 2015 05:59:51 GMT

Hi,

Apply suppress null values property.

Thanks

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 06:12:21 GMT

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

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 06:14:08 GMT

Hi Hariprasadqv,

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

Re: Extra line in chart

MayilVahanan — Wed, 01 Jul 2015 06:14:15 GMT

Try like this

In Dimension tab,

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

Hope it helps

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 06:21:25 GMT

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

Re: Extra line in chart

MayilVahanan — Wed, 01 Jul 2015 06:24:47 GMT

May be its due to some mapping issue.

Re: Extra line in chart

Anonymous — Wed, 01 Jul 2015 06:25:26 GMT

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

Re: Extra line in chart

robert_mika — Wed, 01 Jul 2015 06:55:04 GMT

What if you delete the line from your Excel file?

Re: Extra line in chart

jagan — Wed, 01 Jul 2015 06:57:48 GMT

or else don't load that column into Qlikview?

Regards,

Jagan.

Re: Extra line in chart

tamilarasu — Wed, 01 Jul 2015 07:21:37 GMT

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.