Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

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

Tags (1)
9 Replies
Highlighted

Re: convert to set analysis

What is the expected output here?

Highlighted
Partner
Partner

Re: convert to set analysis

Hi

I have to convert

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


into set analysis.

Highlighted
MVP
MVP

Re: convert to set analysis

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

Highlighted

Re: convert to set analysis

I think this should work

Dimension:

BussinessID

Expression:

FirstSortedValue([Opening Balance], -Datetime)

Highlighted
Partner
Partner

Re: convert to set analysis

yes

Highlighted
Partner
Partner

Re: convert to set analysis

Hi,

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

Highlighted
Partner
Partner

Re: convert to set analysis

hi sunny

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

Highlighted

Re: convert to set analysis

I guess try this:

Dimension:

BussinessID

Expression:

Date(Min(Datetime)

FirstSortedValue([Opening Balance], Datetime)

Highlighted
Honored Contributor III

Re: convert to set analysis

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