Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have requirement like whenever I select one dimension in the graph that dimension name should pass and display in the title of the graph.
Ex:
Suppose I have a bar graph with drill-down dimension like Region->Brand->Product with Sales as a measure.
My requirement is like whenever user clicks on the any region the should look like "NETSALES BASED ON REGION"
When user drill down to next level it should change to Brand like "NET SALES BASED ON BRAND" instead of Region and same with product.
Please let me know is there any way to achieve this requirement.
='NET SALES BASED ON '&getfieldselections(FIELD)
but be aware if they haven't chosen a option in that field it will list all of them
May be you need this:
='NET SALES BASED ON ' & GetCurrentField([Group Name])
Replace [Group Name] with your drill-down group name
Hi Mae
Thanks for your reply.
In this case it is not working with Drill down column name. We can't see the hierarchical column in the expression.
Hi Sunny,
Thanks for your reply.
When I tried with your expression it is saying not a valid function GetCurrentField.
Even I cant see the drill down column in the expression. Help me out
Sorry I did not realize that this was Qlik Sense. GetCurrentField() is not available in Qlik Sense yet. How are you creating the drill-down dimension?
Am creating as usual. You can find the screenshot for the same.