Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
danialier
Creator III
Creator III

Limit the information to show in the second axis

Hello,

I have a Combo Chart showing quarters in X axis and units in columns (Y axis left) and market share in lines (Y axis right) -picture attached-

Picture1.png

I want to limit the number of lines to the top ones (for example the number of lines that sum up to 80% of total market share) plus adding another line showing the rest.

How i can do that ? I tried to do that through the Dimension Limits tab in the Chart Properties but this Dimension Limit refers only to the Period dimension in this case, not to the vendor (lines) dimension...

Please help.

Thanks,

dani

4 Replies
Anonymous
Not applicable

Hi Dani,

Is every line a different Expression?

Because if so, it make sence that limitations on the Dimension does not work.

In that case you should be able to solve bij using conditional show for these expressions.

Good Luck,

Dennis.

danialier
Creator III
Creator III
Author

Hi Dennis,

Actually they are not in different lines in the Expression…

Thks,dani

Anonymous
Not applicable

Can you share you Qlikview document?

So I can take a look?

danialier
Creator III
Creator III
Author

Hi Dennis,

I already resolved this through Conditional functions

Thanks!

dani