Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mlingidi
New Contributor II

How to keep fixed color a one of the bar in bar chart

HI Team,

I have a bar chart where I am showing comparison between two values. one bar will be with a fixed value and the other will get changed when applies filters.

I want to keep one of the bar with a fixed color in bar chart, but when I filter,both the bars(bar with Fixed value and actual value) are getting changed.

Can any one please help me on this.

Thanks,

Murali

8 Replies
shraddha_g
Honored Contributor III

Re: How to keep fixed color a one of the bar in bar chart

can you share a sample app

mlingidi
New Contributor II

Re: How to keep fixed color a one of the bar in bar chart

HI,

Below is my sample  app screen shot where I want to have a fixed color for the bar as highlighted below.

I have written a Color- Custom expression for changing the color for the bar, but its is applying for the both bars.

Please help me on this.

QlikSenseSample.png

Thanks,

Murali

mlingidi
New Contributor II

Re: How to keep fixed color a one of the bar in bar chart

Hi,

Can anyone one help me on the above issue.

Thanks,

Murali !

MVP
MVP

Re: How to keep fixed color a one of the bar in bar chart

Its very hard to diagnose your problem with the limited information provided, so the best anyone will be able to do is guesswork. To avoid guessing games, I suggest you supply more information about the document and the object in question as well as the data model. The best way to do this is to upload a small sample that demonstrates the problem.

shraddha_g
Honored Contributor III

Re: How to keep fixed color a one of the bar in bar chart

What expression you have used in Color by Expression?

What are the 2 Measures you have used?

mlingidi
New Contributor II

Re: How to keep fixed color a one of the bar in bar chart

Hi,

I have given a screen shot of the my requirement in the above thread. If i want to upload my Qvf file how can i do it. I don't see an option to upload a file.

I have a measure --  M1 and Measure -- M2  in the bar chart. My retirement is all the bars of Measure M1 should have a fixed color. M2 should vary color to by filters

shraddha_g
Honored Contributor III

Re: How to keep fixed color a one of the bar in bar chart

Your Screenshot doesn't give an idea about the expression you used.

Refer Uploading a Sample

mlingidi
New Contributor II

Re: How to keep fixed color a one of the bar in bar chart

hi,

Below is the url of my new discussion with Qfv file and  more information on the issue.

How to keep fixed color a one of the bar in bar chart

thanks,

Murali