Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Using Variable In Straight Table

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?

1 Solution

Accepted Solutions
Highlighted
Valued Contributor III

Re: Using Variable In Straight Table

Hi Dermot,

change your variable to

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

by removing the equals sign

And your expression to

$(vKPI.Backlog.#Lines)

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Using Variable In Straight Table

Share screenshot of table.

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

Highlighted
Valued Contributor III

Re: Using Variable In Straight Table

Hi Dermot,

change your variable to

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

by removing the equals sign

And your expression to

$(vKPI.Backlog.#Lines)

View solution in original post

Highlighted
Contributor II

Re: Using Variable In Straight Table

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