Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
Partner
Partner

In the 'bedingung' write

GetCurrentField(BP)<>'Headquarter'

Highlighted
Not applicable

Hey Piet

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

Cheers

Oliver

Highlighted

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

Highlighted
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

Highlighted
Partner
Partner

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'

Highlighted
Not applicable

hi all

thank you very much for your help

Cheers

Oliver