topic Re: Using Variable In Straight Table in QlikView

Using Variable In Straight Table

dmac1971 — Tue, 12 Sep 2017 09:58:15 GMT

I have a simple variable, vKPI.Backlog.#Lines, that allows me to count total lines :

=count({<KPI = {'Backlog'}>}Order_ID)

And as a total count this works fine. When I use this in a straight table using customer as dimension and the following as the exp:

$(=vKPI.Backlog.#Lines)

I get the overall total for all customers against each customer. Is it not possible to use a variable like this in a straight table?

shraddha_g — Tue, 12 Sep 2017 10:01:34 GMT

Share screenshot of table.

What are the fields you have used? and are those linked?

marcus_malinow — Tue, 12 Sep 2017 10:06:04 GMT

Hi Dermot,

change your variable to

count({<KPI = {'Backlog'}>}Order_ID)

by removing the equals sign

And your expression to

$(vKPI.Backlog.#Lines)

dmac1971 — Tue, 12 Sep 2017 10:07:39 GMT

Marcus, Doh! I knew it would be something simple, many thanks!