Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide a dimension in a dynamic group if "XY" is selected

Hi all

I have a table with various KPI's. In the first Columne I have a dynamic group called BP.

This dynamich group contains: 1) BP Headquater, 2) BP Group, 3) BP Outlet/Store

To have an better overview its necessary to have also City in the table, as many customers have several outlets within a country, but they have only 1 headquater. So I need the City information for my Outlet view, but not for the Group or Headquater View.

So, when I select "Headquater" in my dynamic group, City should be hidden, otherwise I  see Total city and not customers headquater.

How can I implement this?

I tried to do this with an if formular, but unfortunately I'm not a developer 😞

Thanks for your help,

Oliver

1 Solution

Accepted Solutions
sunny_talwar

I feel he needs it to show only when the cycle group is on Outlet/Store.

So maybe use this as your condition

GetCurrentField(BP) = 'BP Outlet/Store'

Best,

Sunny

View solution in original post

6 Replies
stigchel
Partner - Master
Partner - Master

In the 'bedingung' write

GetCurrentField(BP)<>'Headquarter'

Not applicable
Author

Hey Piet

Thank you for your fast answer. What is the full formula?

Cheers

Oliver

sunny_talwar

I feel he needs it to show only when the cycle group is on Outlet/Store.

So maybe use this as your condition

GetCurrentField(BP) = 'BP Outlet/Store'

Best,

Sunny

rajeshvaswani77
Specialist III
Specialist III

Hi Oliver,

Please try below formula when you select City in Dimension and in the Bedngung box

if(GetSelectedCount(BP)=0,1,0)

thanks,

Rajesh Vaswani

stigchel
Partner - Master
Partner - Master

It is the full formula, as this is a conditional field QV expects a true false condition, no need to write the if. And Maybe Sunny is right and it needs to be

GetCurrentField(BP) = 'BP Outlet/Store'

Not applicable
Author

hi all

thank you very much for your help

Cheers

Oliver