Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Set Analysis

Hi All,

I have this set analysis, I want to calculate for same but exactly till YESTERDAY. Below is giving me detail till Now.

count({<Segment={'Retail'},PeriodID={$(=Max(PeriodID)) },Fin_Year,MonthYear=,Day=,Date= >} distinct Trans_Key)

I have Date as my Date fieldname.

Please Help

5 Replies
MA1
Not applicable

Re: Set Analysis

hi,

try to use this

PeriodID={"$(=date(max(PeriodID-1)))"}

vinieme12
Not applicable

Re: Set Analysis

what is periodID here? might want to take that out

count({<Segment={'Retail'},Fin_Year,MonthYear=,Day=,Date={"=DATE(Today()-1,'YOURDATEFORMAT')"} >} distinct Trans_Key)

read more here

Dates in Set Analysis

Not applicable

Re: Set Analysis

Not Working, Showing same value

ahaahaaha
Not applicable

Re: Set Analysis

May be Today()-2 in expression?

vinieme12
Not applicable

Re: Set Analysis

post the expression you used or a sample app