Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show one chart only in an aggregated relation

Hi,

When I click on   BHHSH, I have the chart shown in the first snapshot which is good. When I click on the Parent CP – BHPBGRP, it then shown two charts (not good). How do I only shown BHPBGRP only in a single chart as indicated in the second snapshot?

Regards,

Heok

Capture4.JPG.jpg

Capture5.JPG.jpg

7 Replies
Not applicable
Author

select Counterparty_parent as your dimension in your chart.

Not applicable
Author

Thanks Thomas! That is really a good suggestion! However, How do I make the legend of the x-axis to change dynamically according to my selection?

Capture6.JPG.jpg

Not applicable
Author

Im not quite sure what you mean? When you select a counterparty the name changes on the x-axis?

Do you mean a cycle group? instead of the drill-down group you have, i would use cycle group. But can you maybe be more specific on what you mean?

ps. A good thing is to have a listbox at your side, so you can see what you have actually selected - It makes it a little bit easier.

Not applicable
Author

Hi Thomas,

When I click on 'ALL', I will get the legend as 'ALL' as shown in first snapshot (this is correct). However, when I click on BHPBMGRP, I notice the chart changed ( which is correct), but the legend still shown as ALL. I am expecting to have the legend change to BHPBMGRP (second snapshot). Do you know to configure this?

Heok

Capture7.JPG.jpg

Capture8.JPG.jpg

Not applicable
Author

you need to cycle down to conterparty_parent otherwise you cant do so.

Not applicable
Author

i will try to look in to it tonight. Maybe there is a solution to it.

Not applicable
Author

Hi Thomas,

I tried to cycle down to conterparty_parent as suggested, however, when I click on 'ALL' the legend will then shown all the conterparty_parent which is not ideal for me.