Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
In the 'bedingung' write
GetCurrentField(BP)<>'Headquarter'
Hey Piet
Thank you for your fast answer. What is the full formula?
Cheers
Oliver
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
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
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'
hi all
thank you very much for your help
Cheers
Oliver