Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

modifying labels in a chart

I am using a pie chart, in which i get data as 1 and 0. while displaying labels i want 1 to displayed as 'a' and 0 to be displayed as 'b'. Where should i write an expression for this?

1 Solution

Accepted Solutions
Not applicable

modifying labels in a chart

I'm not sure where the 1's and 0's are coming from, but ultimately the expression would be the same.  If you only have 1's and 0's you could add a calculated dimension (right click->properties->dimensions tab) and write in:

=if([Field] = 1, 'a','b')

where field is the data comprised of 1's and 0's.

I think that should get you your desired results.

Hope this helps!

1 Reply
Not applicable

modifying labels in a chart

I'm not sure where the 1's and 0's are coming from, but ultimately the expression would be the same.  If you only have 1's and 0's you could add a calculated dimension (right click->properties->dimensions tab) and write in:

=if([Field] = 1, 'a','b')

where field is the data comprised of 1's and 0's.

I think that should get you your desired results.

Hope this helps!

Community Browser