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: 
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.