Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Graph problem

Hi,

I'm trying to make a chart with a color term.

If the Dimension (It's actually a measure) is bigger than a number (exists in a variable) than green else red.

I'm trying to do this on this kind of Chart.

Thanks.

Problem 1.png

1 Solution

Accepted Solutions
10 Replies
bhargav_bhat
Creator II
Creator II

Hi Meitar,

if you Expand expression then in Background color and Text Color write below expression

if (Variable name >2,red(),green())

Capture.PNG

Regards,

Bhargav

YoussefBelloum
Champion
Champion

Hi

with this kind of graph, you can't do that

Anonymous
Not applicable
Author

I tried that without a success.

Anonymous
Not applicable
Author

I wish you wrong.

YoussefBelloum
Champion
Champion

I already was truck on helping on another thread on qliksense, but it is the same.. one Guy was talking about modifying the css files of the graph..

Maybe it is possible with some tricks.. but not out of the box

Anonymous
Not applicable
Author

I tried also by creating 2 graphs 1 with all the dimension and 1 with the dimension bigger than the variable.

After I will put the one with the less data on the one with all the data.

Problem2.png

My problem is that I'm losing the proportion of x axes.

Maybe someone can assist please?

Thanks

stabben23
Partner - Master
Partner - Master

Hi,

I'll think it better to do 2 Expression.

1. sum({<received_amount={"<=$(=Variable)"}Your Expression)

backgroundcolor red

2. sum({<received_amount={">$(=Variable)"}Your Expression)

backgroundcolor green

stabben23
Partner - Master
Partner - Master

like this

Anonymous
Not applicable
Author

Thanks!