I want to display the label on the cyclic group fields not the group name.

[Anonymous]

List box:

I want to display the label on the cyclic group fields not the group name. How do I do that. if I don't write expression in cyclic group, it does display the label name.

Instead of Cycle I want it to display 'Month'

[Anonymous]

[vinieme12 · Accepted solution]

Check if this works for you

[veidlburkhard]

Hi Pavithra,

this is a very simple thing. As you are using a calculated dimension as second dimension in your group, qlikview cannot display the label you assigned to this dimension. It displays the group name instead. A workaround would be to call the group Year

A better way is to create a new dimension in your script, say %YearFlag:

Chart:

LOAD *,

If(%Year=2015, 'Y', 'N') as %YearFlag;

LOAD * INLINE [

    %Year, %Month, %Salary, %Expenses

    2015 , Jan, 200, 500

    2015 , Feb, 600, 1000

    2015 , Mar, 400, 2000

    2015 , Apr, 800, 1000

    2015 , May, 700, 7000

    2015 , Jun, 500, 7546

    2015 , Jul, 200, 4671

    2015 , Aug, 100, 7624

    2015 , Sep, 900, 1548

    2015 , Oct, 100, 3289

    2015 , Nov, 200, 8137

    2015 , Dec, 300, 7912

    2016 , Jan, 700, 4516

    2016 , Feb, 400, 7316

    2016 , Mar, 500, 7943

    2016 , Apr, 800, 9000

    2016 , May, 900, 8700

    2016 , Jun, 700, 1500

    2016 , Jul, 200, 2000

];

In your chart you then define a group (whatever name) from %month and %YearFlag. Please label these dimensions 'Month' and 'Year' accordingly and you will see in your listbox you can switch from Month to Year and vice versa.

Hope this helps

Burkhard

[Anonymous]

This Sound good too. I did not wanted to reload the app. That's why I wanted to find out quick method to change using Expression in the cyclic group.

Thanks

Pavi

[vinieme12]

have you checked the app i posted?

[Anonymous]

Thank you so much. particularly for this case, your answer is the best solution.

[Anonymous]

Yes, I did. Thank you so much for helping me.

[rwunderlich]

Ok, I understand now. Glad you found a workaround.  I do think it's a bug and should be reported to QT Support if you have time.

-Rob

[Anonymous]

Yes, I think so too! Sure, I will do when I get time. Thanks