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