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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nawaz15
Contributor
Contributor

Error

Hi Everybody,

I am facing an issue in chart script i wanted peer values displayed based on the business model, here suppose a corporate is selected it should display the respected peers in the below table.

 

nawaz15_0-1714304457874.pngnawaz15_1-1714304490739.png

 

Labels (3)
2 Replies
igoralcantara
Partner Ambassador/MVP
Partner Ambassador/MVP

What is the chart script you are using?

Check out my latest posts at datavoyagers.net
nawaz15
Contributor
Contributor
Author

Aggr(1-${<UniqueBusinessModel = {$(vCurrentSelectedBusinessModel)}>}, CorporateName)

Here i am group it by CorporateName and ignoring the current selection, 

vCurrentSelectedBusinessModel will return the business Model of current Selected Value

for that i have use only function

=only({<CorporateName = {'$(vCurrentCorporateName)'}>} UniqueBusinessModel)