Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing/Customizing the dimension values on x-axis



Hi guys,

I need to change the dimension values which come up in the chart on x axis to some customized text or numbers

REASON: The dimension is webpage, it's very much long and consequently not visible on the chart fully. Only https://... is visible on the chart.

chart http qlikview.png

As you can see for all the bars, it is absolutely not visible for what page, the no of visits is 140 or 131 or 86 and so on.

I need to have a dynamic value for the page diomension. like for first bar it should come as 1, for second as 2 third as 3 and so on. I also need to provide legend for these '1' , '2' and '3' etc values, i.e. what page they refer to. I have tried a lot of work arounds but couldn't get my hands on anything substancial. Iam sure there must be a way out as it is a recurring problem...

Please help.Urgent.

1 Reply
Not applicable
Author

Hi Swati,

I'm unaware of such built-in functionality in QV but you may want to post it amongst the ideas as it would be really handy to have that!

Regarding your problem, if it's urgent your best bet is probably to add a display-friendly name to your table. If you have finite many possible values for web addresses, this should not be too complicated. You could use applymap to put it neatly next to the actual address. Once you've got them there, you can use the display-friendly name in the bar chart and maybe also display the full address next to the bar chart in a straight table (that would ensure you can display the same values as what you have under the bars).

Another possibility would be to simple increase the space there (you can resize the inner sections of the chart object by making it active and then pressing CTRL+SHIFT and using the mouse when the red lines appear). This, of course, only works if you can make more space for the chart on the page.

You could also shorten the displayed values on Presentation -> Legend --> Limit Legend.

If none of these work, because you have a lot of possible values that could come up on the chart and absolutely no more space for the object on the page, you may need to create a table in your script where you can represent every value with a number like you suggested in the initial post. However, the problem is there will no guarantee they will be displayed in the right order on the chart which may make it look rather odd.

Finally, one of the simplest options would to create a display-friendly name just simply via removing the https//: bit. You can use the substring function in your load script to this and it would ensure at least the first couple of characters of the actual domain are displayed.