topic Re: Strange(Confused) line chart when using show others and show total together in Dimension limit in QlikView

Strange(Confused) line chart when using show others and show total together in Dimension limit

uacg0009 — Wed, 13 Jul 2016 08:57:39 GMT

Hi all,

I met a strange issue, I don't know whether it's a bug or not. I created a line chart to show top 10 order numbers by company using

And it shows well and also when I using show others :

But when I select show others and show total together, the line chart change to :

You can see that the table confuse the other and total, and I don't know why...

Dimension : 1. year 2. company

expression: count ( order )

There are some orders that don't have company, so I suppress the null in company dimension, I don't know whether it will influence.

Do you know how to solve that ?

If you need any other information please tell me.

Thanks.

Aiolos Zhao

uacg0009 — Thu, 14 Jul 2016 03:19:46 GMT

Anyone knows what's the matter with this?

uacg0009 — Fri, 15 Jul 2016 02:07:24 GMT

Any ideas about this?

pavan045 — Fri, 15 Jul 2016 06:02:45 GMT

When you check 'Show total' , the graph is showing total for that particular year with normal trend. I think you better uncheck that.

I don't see any requirement to show total in the mentioned chart.

Thank you

uacg0009 — Fri, 15 Jul 2016 08:31:14 GMT

Hi Pavan,

Thanks for reply, and I also just want to show others, but my boss wants show total and show others, then I find the bug.

Well, do you know why?

Thanks.

Aiolos Zhao