topic Re: Graph problem in QlikView

Graph problem

Anonymous — Thu, 25 Jan 2018 13:02:24 GMT

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.

Re: Graph problem

bhargav_bhat — Thu, 25 Jan 2018 13:20:08 GMT

Hi Meitar,

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

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

Regards,

Bhargav

Re: Graph problem

YoussefBelloum — Thu, 25 Jan 2018 13:24:25 GMT

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

Re: Graph problem

Anonymous — Thu, 25 Jan 2018 13:27:43 GMT

I tried that without a success.

Re: Graph problem

Anonymous — Thu, 25 Jan 2018 13:28:18 GMT

I wish you wrong.

Re: Graph problem

YoussefBelloum — Thu, 25 Jan 2018 13:31:37 GMT

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

Re: Graph problem

Anonymous — Thu, 25 Jan 2018 13:37:45 GMT

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.

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

Maybe someone can assist please?

Thanks

Re: Graph problem

stabben23 — Thu, 25 Jan 2018 15:05:20 GMT

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

Re: Graph problem

stabben23 — Thu, 25 Jan 2018 15:11:37 GMT

like this

Re: Graph problem

Anonymous — Thu, 25 Jan 2018 15:30:20 GMT

Thanks!

Re: Graph problem

YoussefBelloum — Thu, 25 Jan 2018 15:51:28 GMT

smart approach