topic Re: Referencing an Expression in QlikView

Referencing an Expression

Anonymous — Tue, 06 Jan 2015 18:08:15 GMT

I have two expressions in a chart. The first is "Nbr Customers" defined as COUNT(USER_ID). The second expression is "Total Customers" defined as COUNT(USER_ID) with the "Full Accumulation" option set. This provides a rolling total of the number of customers.

I need to be able to highlight the value of second expression ("Total Customers") when it reaches 70% of the total number of customers (COUNT(USER_ID) * .7).

Is there a way to reference the second expression with the Full Accumulation option set in another expression? How do you code that expression with the Full Accumulation option set?

Thoughts?

Thanks,

Ed T.

Re: Referencing an Expression

chrismarlow — Tue, 06 Jan 2015 18:35:11 GMT

Not sure this would be exactly what you are after, but you could highlight using Visual Cues tab, and use TOTAL in the count to return total, something like;

Re: Referencing an Expression

Colin-Albert — Tue, 06 Jan 2015 18:39:41 GMT

In the same chart, you can reference expressions by their label name. If the label contains spaces then you must add square brackets around the name.

e.g. In your chart you could add a third expression as

=[Nbr Customers] / [Total Customers]

Re: Referencing an Expression

terezagr — Tue, 06 Jan 2015 18:49:30 GMT

You can do that in expression. Click on + sign next Expression(Total Customers) to expand the options.

Than in the background option add this expression:

=if((COUNT(USER_ID) * 0.7),RGB(red))

Re: Referencing an Expression

Anonymous — Tue, 06 Jan 2015 19:59:25 GMT

Thanks, Colin. This is the syntax I was looking for.