Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Valued Contributor III

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

Tags (3)
1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: bar values

write calculated dimension like

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

5 Replies
arulsettu
Honored Contributor III

Re: bar values

write calculated dimension like

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

soniasweety
Valued Contributor III

Re: bar values

thanks arul its works

how can I give the dimension label colour?

arulsettu
Honored Contributor III

Re: bar values

if you want to give different color to bar check this

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

Re: bar values

....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
Valued Contributor III

Re: bar values

thanks arul and Bill

Nice docs I will go through it .

Thanks

Sony