Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator III
Creator III

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
marcus_malinow
Partner - Specialist III
Partner - Specialist III

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
shraddha_g
Partner - Master III
Partner - Master III

Share screenshot of table.

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

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Hi Dermot,

change your variable to

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

by removing the equals sign

And your expression to

$(vKPI.Backlog.#Lines)

dmac1971
Creator III
Creator III
Author

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