Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Dynamic Label

Hi All,

i have a bar chart which have measures as current year,Previous year and Previous to previous year.

and the labels for the above measures are CY, PY and PPY.

My Requirement is: want to display label as CY-2017, PY-2016 and PPY-2015 (should be dynamic)

can anyone help me.

Thanks,

Rathnam.

7 Replies
sarvesh
Creator III
Creator III

Hi.. Rathnam,

For this requirement, you add a drop down list of year by which user can chose year.

Regard's

Sravesh Srivastava

Anonymous
Not applicable

As far as I know out of the box Bar Chart measure labels cannot be defined by a dynamic expression, only by static text.

You can though have expression defined dynamic Titles, SubTitles and Footnotes.

dsharmaqv
Creator III
Creator III

try like this in label section

='CY - ' & '$(vSelected_Month)'

='PY - ' & '$(vSelected_Month)-1'

='PPY - ' & '$(vSelected_Month)-2'

define variable

vSelected_Month

=GetFieldSelections([Report Period])

Hope I understood it correctly

rathnam_qv
Creator
Creator
Author

Hi Deepak,

I tried this but it is treating everything as text.

Thanks,

Rathnam.

dsharmaqv
Creator III
Creator III

can you please post your app

rathnam_qv
Creator
Creator
Author

Hi Deepak,

i am not able to see attach option to attach my app.

Thanks,

Rathnam.

rathnam_qv
Creator
Creator
Author

Hi Deepak,

If u can share your personal id, i will send my qvf.

Thanks.