topic Re: How to write condition on Bar graph? in QlikView

How to write condition on Bar graph?

Thu, 25 Jun 2015 22:46:33 GMT

Hi all,

I need to create a bar graph in which salary is a dimension.

If salary > 10000 , then I need to show in red or green.

Please post you answers.

--- Arun

Re: How to write condition on Bar graph?

ramoncova06 — Fri, 26 Jun 2015 00:29:00 GMT

under the expresion it has a plus sign "+" click on it to expand it, under background add the condition if(If salary > 10000, red(), green())

Re: How to write condition on Bar graph?

Fri, 26 Jun 2015 02:41:00 GMT

I don't know why you need to add salary as a dimension.

But if you want to add conditional colouring based on salary, you can go to Chart properties->Expression->expression(click on + icon in expression)->Background Colour -> Definition and write condition as per below example.

=If(Sum(UnitPrice/1000) <= 20,LightRed(),if(Sum(UnitPrice/1000) <40,Yellow(),LightGreen()))

Re: How to write condition on Bar graph?

Mon, 27 Jul 2015 23:43:37 GMT

Thanks all... Its helpful

Re: How to write condition on Bar graph?

vardhancse — Tue, 28 Jul 2015 08:15:30 GMT

If you are okay with the solution, please mark the thread as correct answer. So that it might be helpful to others