Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
Check if this works for you
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
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
have you checked the app i posted?
Thank you so much. particularly for this case, your answer is the best solution.
Yes, I did. Thank you so much for helping me.
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
Yes, I think so too! Sure, I will do when I get time. Thanks