Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

bar values

hi all,

I have field like  Model in that I have values like  0,1

0 means existing

1 means not existing

in bar chart if I take dimension as  model    am getting  bars  as 0,1     but I want to show in place of 0 existing   for 1  notexisting

how can I do?bar.PNG

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

write calculated dimension like

if(Model='0','existing','notexisting')

View solution in original post

5 Replies
arulsettu
Master III
Master III

write calculated dimension like

if(Model='0','existing','notexisting')

soniasweety
Master
Master
Author

thanks arul its works

how can I give the dimension label colour?

arulsettu
Master III
Master III

if you want to give different color to bar check this

Qlik Sense: How to set custom colors by measure in a bar chart

Anonymous
Not applicable

....or use the Dual() function in the load script, that way you can have the best of both worlds.

Here is the link the the Help Dual - script and chart function ‒ Qlik Sense

And here is a Blog about it QlikView Addict: QlikView Functions: dual()

It work exactly the same QlikView vs. Sense.

soniasweety
Master
Master
Author

thanks arul and Bill

Nice docs I will go through it .

Thanks

Sony