Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis sum first value in a series of values

Hello,

I'm using this set expression to get the ingoing balance for each month and it works fine even if I select multiple Dates. But when I select multiple months the expression sums the total value for the first found value of each selected month. I want the expression to sum the first occurrence disregarding whatever Date, Month or Year selections I've made.

=sum( {<Date = {'>=$(=date(min(Date))) <=$(=min({Date} Date))'} >} MyValue)

2 Replies
Not applicable

SV:Set analysis sum first value in a series of values

Anyone?

MVP
MVP

SV:Set analysis sum first value in a series of values

Hi,

Though i am not very clear about your requirement, let's share what i have understood. it seemed that you want a single Date to be filtered which is the first occurance of your condition. if it is so, then better you use a variable to find it and then use it in the set analysis as Date= {$(#Variable)}.One more thing, would you please explain the second portion of your set analysis i.e $(=min({Date}Date)).... is it working fine?

Regards,

tresesco

Community Browser