Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
meitargold
New Contributor III

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
stabben23
Honored Contributor

Re: Graph problem

like this

10 Replies
bhargav_bhat
Contributor II

Re: Graph problem

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
Esteemed Contributor

Re: Graph problem

Hi

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

meitargold
New Contributor III

Re: Graph problem

I tried that without a success.

meitargold
New Contributor III

Re: Graph problem

I wish you wrong.

YoussefBelloum
Esteemed Contributor

Re: Graph problem

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

meitargold
New Contributor III

Re: Graph problem

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
Honored Contributor

Re: Graph problem

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
Honored Contributor

Re: Graph problem

like this

meitargold
New Contributor III

Re: Graph problem

Thanks!