(Drill Down Group)Display all dimensions with selected values on chart title

[s10157754]

Dear Qlikview Expert,

I would like to seek help from you on writing syntax to display all dimensions with selected values of a drill-down group on title. I have more than 2 dimensions in the drill-down group. In this case, I just take 'Month' and 'Day' for reference.

The picture below shows how my drill-down group bar chart looks like.

For example, when user click on 'Month' bar chart. Let say Jun.

I would like to show selection with value on chart title. e.g.( Month: Jun)

When drill down into 'Day' bar chart and user continue to click on anyone of the days. Let say 16th.

I would like to show selection with value on chart title. e.g.( Month: Jun & Day: 16th)

So when user drill down they can just look at the chart title to see what are the selections they have made previously. Any ideas from you all would be greatly appreciated!

[Anonymous]

You can use get current selections for this.  Add it to the Title Text box with the corresponding fields.  For example: =GetCurrentSelections(Month). 

[s10157754]

Dear Kathleen,

Your expression tend to show all the selections in the dashboard made by the user. I only want to show the selection made by the user for that particular drill-down group chart. In chart title, I tend to put the expression as:

=GetFieldSelections(Year,Month,Day)

But it doesn't even work. Any ideas from you? Thanks a lot in advance. 

[vishsaggi · Accepted solution]

May be this?

= Concat(GetCurrentSelections(Cyclic1), ',' )

Dont even need any group name to be mentioned.

Just use GetCurrentSelections() in your Chart Title.

[s10157754]

Dear Vishwarath,

Thanks for your idea, I think I will just create 3 text objects to display the individual selected field.

Best Regards,

Qian Ning