Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlikView question:
I have a drill-down group "LocationGroup" comprising (Country, State, County, City) and when I am displaying a sub-level I want to see where I am in the group.
E.g. if I am have drilled down to California I can see the counties but I want to display "California" in the title (or better still the whole path from the top "USA/California").
Post some dummy data or your app.
usuall getcurrentfiled() or getfieldselections() are used but cannot guarantee untill i have a look at the report or the data atleast
How about something like this:
=only(Country) & ' > ' only(State) & ' > ' & only (County) & ' > ' only (City)
The function only() will only return a single available value. You can enhance the formula with the IF() conditions that could replace the default NULL value for multiple values with the space or with the text "multiple Countries", for example.
cheers,
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
try this (check the syntax as I don't have your data)
=
chr(10)
& if(GetCurrentField([LocationGroup])='State', Country)
& if(GetCurrentField([LocationGroup])='County', Country & chr(10) & State)
& if(GetCurrentField([LocationGroup])='City', Country & chr(10) & State& chr(10) & County)
& chr(10) & ' '
Excellent! Not elegant but it does the job.
Even better. Thanks.
Hi,
There is no direct function available, but you can use the variables with if statement to get what you want.
Have a look at the attached example.
Regards,
Kaushik Solanki