topic Re: Variable in Set analysis Article value in QlikView

Variable in Set analysis Article value

Wed, 25 Nov 2020 16:16:04 GMT

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 !

swuehl — Thu, 07 Apr 2016 10:54:29 GMT

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)

Thu, 07 Apr 2016 10:58:02 GMT

Hello swuehl,

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

swuehl — Thu, 07 Apr 2016 11:54:06 GMT

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