Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

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
Esteemed Contributor

Re: Set Analysis Question

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?

2 Replies
awhitfield
Esteemed Contributor

Re: Set Analysis Question

All members of the dimension

e.g. All Invoice Months and Invoice years

Andy

omarbensalem
Esteemed Contributor

Re: Set Analysis Question

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?