2

Just wondering how to get a selected value in an expression. I have the following bar chart, with drill down from Year to months.

QlikView chart Before Drill down

When I click say 2011 bar I get the following chart.

QlikView chart After Drill down

Now is there a way to get Transported Mail - 2011 in the second chart instead of just plain Transported Mail. Note that 2011 is the current selected year. I want it to be incorporated in the label expression. Please guide.

Cœur
  • 37,241
  • 25
  • 195
  • 267
VivekDev
  • 20,868
  • 27
  • 132
  • 202

1 Answers1

1

You can use set analysis for this...

Try this:

= 'Transported Mail -' & concat({state_name} DISTINCT year_var,',')

Note If you haven't created any alternate states, you can use $ as your state_name

Now, you can get much more complicated with this to allow it to handle multiple years differently, but this should do the trick for you.

bdiamante
  • 15,980
  • 6
  • 40
  • 46
  • Perfect. It worked. The following is the expression. = 'Transported Mail -' & concat({$} DISTINCT Year,',') – VivekDev Dec 09 '14 at 07:27