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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HOW TO CHANGE LABELS OF DIMENSIONS?

Hey friends, i have a problem.

I have a CHART, with one dimension called COMPANY.

under COMPANY, i have the names of different companies, such as SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

how do i change the COMPANY label, such that, when i open the CHART, it only has APPLE and DELL under the COMPANY dimension.

So basically,

1) 1 CHART with a COMPANY dimension.

2) COMPANY : SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

3)modify COMPANY dimension such that, COMPANY only has APPLE and DELL.

4)ONLY CHANGE THE LABEL OF THE DIMENSION TO MAKE THIS WORK.

Can this be accomlished? THANK YOU!!! 😄

1 Reply
Not applicable
Author

Not sure what you mean by this. Do you only want APPLE and DELL to show in the graph, or only have a lable on the APPLE and DELL bars, but still see bars for the others?

I think you can do it via an if statement: If (COMPANY='APPLE' OR COMPANY='DELL',COMPANY,'N/A').

If you put that in the lable statement it should only put lables for those 2. If you use a similar statement in the expression it will only show data for those 2.