Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable in Set analysis Article value

hello all,

i want to see a result in a straight table which must show the transactionquantity from all NOSArticles.

first i made a variable called vNosArticle. an then created a straight table with a expression Nos Article transactionquantity.

the currect variable of vNosArticle:

=IsNOS=1

the current expression for Nos Article transactionquantity;

sum({$<ArticleNumber = {$(vNosArticle)}>}TransactionQuantity)

unfortunatly i dont see any data in my straight table (see image below). can somebody help me?

Many thanks !

3 Replies
swuehl
MVP
MVP

Try

sum({$<ArticleNumber = {"=IsNOS=1">}TransactionQuantity)


Do you see any results in your table then?


If yes, defines your variable like


= chr(34) & '=IsNOS=1' & chr(34)

Not applicable
Author

Hello swuehl,

i don't see any value....:(

swuehl
MVP
MVP

Then please provide a small sample so we understand your data model.