Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Can I use alternate state to make label in the chart properties, dynamic?

Hi,

I have a comparative analysis chart which uses selection over 2 different groups/states (Dim Group 1 and Dim Group 2).

I have managed to make the comparative analysis work but i am trying to make the label of the chart also dynamic so that when a user selects Year and Quarter for Period 1 of analysis, in the table it shows that particular selection (for example: Q2,2010) and same for Period 2(Q1,2012)Joshua Burton.

Thanks

Vipul

2 Replies
MVP
MVP

Re: Can I use alternate state to make label in the chart properties, dynamic?

Yes in the label for Period 1 you can put:

=Qtr & ',' & Year

And in the label for Period 2 you can put:

=MinString( {Altstate1} Qtr) & ',' & MinString( {Altstate1} Year)

Not applicable

Re: Can I use alternate state to make label in the chart properties, dynamic?

Thanks Petter,

=MinString( {Altstate1} Qtr) & ',' & MinString( {Altstate1} Year)

The above expression was helpful in making it to display the period that was selected. But this is not working correctly in case of multiple selection of year and Quarter.

I tried using :

=GetFieldSelections({[Dim Group 1]}Cal_Quarter) & ',' & GetFieldSelections( {[Dim Group 1]}Cal_Year)

But it gives an error.


Could you suggest, how can i get that working for multiple selections.

Thanks

VN

Community Browser