topic Re: Using variables in charts in QlikView

Using variables in charts

Wed, 25 Nov 2020 16:16:04 GMT

I have a line chart. In one of the expressions I use symbols (Points) to represent it. I want each of these points to be painted with one color of another depending of some conditions.

Then I defined background color using this expression (method 1):

target_orders

which is a variable that I have defined as below:

=if(numOrders < 10, Green(), If(numOrders >= 10 and numOrders <= 50, Yellow(), Red()))

and numOrders is another variable as below:

=sum({$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0))

but it seems background color is not correctly being displayed for each point in the chart.

Method 2:

However if I put the full expression as background color as below (without using variables):

=if(sum({$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0)) < 10, Green(), If(sum({$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0)) >= 10 and sum({$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0)) <= 50, Yellow(), Red()))

then each point is being displayed with the correct color.

So why QlikView is interpreting it differently if I use method 1 or method 2?

I would like to use variables as expression is clearer and readable than putting the full expression in method 2.

How can I obtain the same results as method 2 using variables in method 1?

Re: Using variables in charts

sunny_talwar — Mon, 08 Aug 2016 09:55:25 GMT

May be you will need to play around with dollar sign expansion or try adding or removing equal sign from the variable definition.

Re: Using variables in charts

Mon, 08 Aug 2016 10:39:50 GMT

Doing this seems the behaviour is the same as method 2:

Method 1:

Background color expression:

$(=target_orders)

which is a variable that I have defined as below:

if($(=numOrders) < 10, Green(), If($(=numOrders) >= 10 and $(=numOrders) <= 50, Yellow(), Red()))

and numOrders is another variable as below:

sum({$<[Order Type] = {'A'}>}if([quantity] > 20000.0, 1,0))

The problem now is that all the symbols (points) are being painted with the same color.

Re: Using variables in charts

sunny_talwar — Mon, 08 Aug 2016 10:44:37 GMT

Would you be able to share a sample?

Re: Using variables in charts

marcus_sommer — Mon, 08 Aug 2016 10:47:02 GMT

I think your variables should look like:

$(target_orders)

if($(numOrders) < 10, Green(), If($(numOrders) >= 10 and $(numOrders) <= 50, Yellow(), Red()))

- Marcus

Re: Using variables in charts

Mon, 08 Aug 2016 10:48:59 GMT

I cannot as it is confidential (work material). But for example, I have a line chart with one expression. This expression is being represented with point symbols (not line). Then depending on some conditions I want each points of the same expression to be painted with red, yellow or red color. Is it possible to paint each point of the same expression with different colors based on condition? I think this is the problem, in the same expression maybe it is not possible so all the points in my case are painted with the same color. How can I do this? better to add another post for this.