topic Re: convert to set analysis in QlikView

convert to set analysis

gauravgg — Wed, 08 Mar 2017 11:47:25 GMT

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

Hi Please find the attached excel for data

sunny_talwar — Wed, 08 Mar 2017 11:56:25 GMT

What is the expected output here?

gauravgg — Wed, 08 Mar 2017 11:58:23 GMT

I have to convert

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

into set analysis.

MK_QSL — Wed, 08 Mar 2017 11:59:12 GMT

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

sunny_talwar — Wed, 08 Mar 2017 12:00:10 GMT

I think this should work

Dimension:

BussinessID

Expression:

FirstSortedValue([Opening Balance], -Datetime)

gauravgg — Wed, 08 Mar 2017 12:00:16 GMT

yes

Aurelien_Martinez — Wed, 08 Mar 2017 16:23:19 GMT

Hi,

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

gauravgg — Thu, 09 Mar 2017 05:25:51 GMT

hi sunny

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

sunny_talwar — Thu, 09 Mar 2017 09:44:05 GMT

I guess try this:

Dimension:

BussinessID

Expression:

Date(Min(Datetime)

FirstSortedValue([Opening Balance], Datetime)

sasiparupudi1 — Thu, 09 Mar 2017 09:51:08 GMT

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