qs variable extension

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

I have created bar chart with Two dimensions Age Group and Income and One Measure as Payments

These two dimensions are linked with qs variable extension those are Age Group and Income.

Here the chart is visible when I have clicked on Age Group button only. Is this possible to show Age Group wise Payments as default and when i click on Income button Income wise payments need to show.

Please find the attached app.

Thanks in advance.

[Ivan_Bozov · Accepted solution]

Hi, see attached. Is this what you are looking for?

[bhavvibudagam]

Great Solution..

Thanks a lot

[Ivan_Bozov]

No worries, glad it works.

[bhavvibudagam]

Hi Ivan,

Could you please suggest how to create a dynamic Title  which need to show Payments by  Age Group as default title then by click on Income button then its need to display Payments by Income

I have tried like below but not working by default. When i have click on button its working. Please find the app.

='Payments by' & '-' &

if('$(vDimension)'='[AGGR.Age Group]', 'Age Group'

if('$(vDimension)'='Income','Income'))

Thanks in advance

[Ivan_Bozov]

Maybe try

='Payments by' & '-' & '$(vDimension)'

This should work on app opening.