Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
uacg0009
Partner - Specialist
Partner - Specialist

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

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

Line Chart.JPG

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

Line Chart1.JPG

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

Line Chart2.JPG

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

4 Replies
uacg0009
Partner - Specialist
Partner - Specialist
Author

Anyone knows what's the matter with this?

uacg0009
Partner - Specialist
Partner - Specialist
Author

Any ideas about this?

pavan045
Contributor III
Contributor III

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
Partner - Specialist
Partner - Specialist
Author

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