Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Is it possible to pass the parameter based on the selection!

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.

Tags (2)
6 Replies
bellamae
Not applicable

Re: Is it possible to pass the parameter based on the selection!

='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

sunny_talwar
Not applicable

Re: Is it possible to pass the parameter based on the selection!

May be you need this:

='NET SALES BASED ON ' & GetCurrentField([Group Name])

Replace [Group Name] with your drill-down group name

Not applicable

Re: Is it possible to pass the parameter based on the selection!

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.

Not applicable

Re: Is it possible to pass the parameter based on the selection!

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

sunny_talwar
Not applicable

Re: Is it possible to pass the parameter based on the selection!

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?

Not applicable

Re: Is it possible to pass the parameter based on the selection!

Am creating as usual. You can find the screenshot for the same.

Drill down.JPG