Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi I have a chart shown as following, I would like to
1. change the dimention of grade from 'A.xpb' to 'A'. How could I do it either in script or directly in the chart?
2.I would like to label each grade in their area, such as lable 'E' in the green area.
Thanks so much!
For the first question you just need to place the name what you need in label field.
Or rename it in the script with
A.xpb AS A
Thx, but it seems to change the name of the label not each exact value of the label. In my sample if I choose the label box and it just change the show of 'Grade' not the 'A.xpb' to 'A'.
In the script I don't know how to change it seam it is the value of one variable, I could only load the [Grade] field....
Do you have another method?
Oh.. I see.
So you need to add into the script
,Pick(WildMatch(Grade, 'A*','B*','C*','D*','E*'), 'A','B','C','D','E') AS NewGrade
Reload script and use NewGrade as dimension
1. You can use Pick(WildMatch(Grade, 'A*','B*','C*','D*','E*'), 'A','B','C','D','E') as @ Sergey Makushinsky Or else write a if condition.
2. I am not sure. But you can re-arrange the position of the labels by holding shift+cntrl keys and move the label panel to desired location.
Thx! The first question has been solved...And what's your opinion for the second question?
For the second question I would like to get the chart like this
Each label lay in their area...What can I do?
The second question..
I don't think that it's a good idea, because you don't know where you able to put it because of weight...
But I need to think it over.
Instead you can do something like this....
Yes...It's the chart what I want ...
But what I want to change is the label of the chart.....I know that excel could do so but I am not sure about the QV....