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: 
rittermd
Master
Master

Set Analysis Question

I inherited an app and I am not quite sure what is being done here:

sum({$<Invoice_Month={'*'}, Invoice_Year={'*'},PrevPeriod_Ind={"-1"}>}Invoice_LineTotal)

What are Invoice_Month and Year doing in this expression?

1 Solution

Accepted Solutions
OmarBenSalem

Hi Mark,

Invoice_Month={'*'}, Invoice_Year={'*'}


is like writing :

Invoice_Month=, Invoice_Year=

and for both cases, what it's doing is forcing Qlik to always calculate the sum of invoice line for ALL the Invoice_Year and ALL the Invoice_Month no matter the selection you make on those 2 fields.


If you have for example, Invoice_Year :2015,2016 and 2017 and you select 2017;

This expression won't return the the sum of invoice line for the selected year 2017; but for all the existing Years (2015,2016 and 2017)
Clear enough?

View solution in original post

2 Replies
awhitfield
Partner - Champion
Partner - Champion

All members of the dimension

e.g. All Invoice Months and Invoice years

Andy

OmarBenSalem

Hi Mark,

Invoice_Month={'*'}, Invoice_Year={'*'}


is like writing :

Invoice_Month=, Invoice_Year=

and for both cases, what it's doing is forcing Qlik to always calculate the sum of invoice line for ALL the Invoice_Year and ALL the Invoice_Month no matter the selection you make on those 2 fields.


If you have for example, Invoice_Year :2015,2016 and 2017 and you select 2017;

This expression won't return the the sum of invoice line for the selected year 2017; but for all the existing Years (2015,2016 and 2017)
Clear enough?