Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thierrytt1102
Partner - Creator II
Partner - Creator II

set analysis aggr function

Dear,

I'm developping an application concerning the sales of the 3 first months of a car.

Something like this:

Modelrelease dateSales of the first 3 months
car 101/03/20141000 € (from 01/03/2014 to 01/06/2014)
car 202/03/20132000€
car 301/01/20123000€

In a straight table.

I'm using the expression:

sum({< [Period]=,[Day]=,[Weekday]=,[Year]=,[Month]=,[Quarter]=,[_MonthSerial]=,[_QuarterSerial]=,[_WeekSerial]=,[Year-Month]=,

Period={">=$(=only(ReleaseDate))"}*{"<=$(=addmonths(only(ReleaseDate),2))"}

>} Sales)

It is working fine when I select 1 car in my list box but not when I want to see all my vehicles.

I tried with an aggr function in my set analysis but no results.

Thx for your help

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

He!

Just replace you conditions with Period in somthing like this

sum({$<...>} if(Period>ReleaseDate and Period<=addmonths(only(ReleaseDate),2), Sales))

View solution in original post

2 Replies
pokassov
Specialist
Specialist

He!

Just replace you conditions with Period in somthing like this

sum({$<...>} if(Period>ReleaseDate and Period<=addmonths(only(ReleaseDate),2), Sales))

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

That doesn't look beautiful to me ... but it works!

thx