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: 
gauravgg
Partner - Creator
Partner - Creator

convert to set analysis

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))

Hi Please find the attached excel for data

Convert to set analysis

9 Replies
sunny_talwar

What is the expected output here?

gauravgg
Partner - Creator
Partner - Creator
Author

Hi

I have to convert

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))


into set analysis.

MK_QSL
MVP
MVP

I think he wants Opening Balance total for each BusinessID on Minimum DateTime.

sunny_talwar

I think this should work

Dimension:

BussinessID

Expression:

FirstSortedValue([Opening Balance], -Datetime)

gauravgg
Partner - Creator
Partner - Creator
Author

yes

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Sum({<Datetime={'$(=Date(Min(Datetime)))'}>} OpeningBalance)

Help users find answers! Don't forget to mark a solution that worked for you!
gauravgg
Partner - Creator
Partner - Creator
Author

hi sunny

I have to group businessid and get the min date of that particular businessid and its opening balance value

sunny_talwar

I guess try this:

Dimension:

BussinessID

Expression:

Date(Min(Datetime)

FirstSortedValue([Opening Balance], Datetime)

sasiparupudi1
Master III
Master III

=sum({<Datetime={'$(=Aggr(MinString(Datetime),BusinessID))'}>}[Opening Balance])