topic Re: Set analysis -Same date expression in QlikView

Set analysis -Same date expression

Anonymous — Tue, 05 May 2015 12:29:23 GMT

Hi All ,

Please help me in solving the set analysis expression, for finding count of same day delivered vehicle .

IF ( Invoicedate = Jobopendate) then it is same day delivered vehicle

Example

Count( <{Invoicedate = Jobopendate >} VehicleNo)

Thanks in advance

Re: Set analysis -Same date expression

tresB — Tue, 05 May 2015 12:32:47 GMT

Try like:

Count( <Invoicedate={"=Invoicedate = Jobopendate"} >} VehicleNo)

Re: Set analysis -Same date expression

sunny_talwar — Tue, 05 May 2015 12:33:41 GMT

Set analysis is evaluated once per chart and won't work in this case. Try this instead:

Count(If(Invoicedate = Jobopendate, VehicleNo))

Re: Set analysis -Same date expression

sunny_talwar — Tue, 05 May 2015 12:35:03 GMT

I guess I am wrong. But I thought set analysis is evaluated/calculated once per chart? tresesco‌ would you be able to explain why it will work for this case?

Best,

Sunny

Re: Set analysis -Same date expression

tresB — Tue, 05 May 2015 12:39:59 GMT

I have not found mentioning a chart in the question. And you are right, set analysis evaluates once per object, but that necessarily doesn't say that set analysis can't be used in a chart. That would actually depend on the dimension. And, that too not mentioned in the query post. Isn't it? Am i missing something?

Re: Set analysis -Same date expression

maxgro — Tue, 05 May 2015 12:41:29 GMT

please post your data if possible

if not I'll give you an idea of the syntax

count({<SomeKey = {"=(Invoicedate=Jobopendate)" } >} VehicleNo)

Re: Set analysis -Same date expression

sunny_talwar — Tue, 05 May 2015 12:41:31 GMT

I guess you are right. I assumed it to be within a chart

Thanks for clarifying

Best,

Sunny

Re: Set analysis -Same date expression

buzzy996 — Tue, 05 May 2015 12:45:30 GMT

some thing like,

=Count( {$<Invoicedate={'Jobopendate'}>} VehicleNo)

Re: Set analysis -Same date expression

sunny_talwar — Tue, 05 May 2015 12:48:31 GMT

tresesco‌ this seems to be working in the chart as well where I have MonthName(Invoicedate) as an dimension.

by this I mean the expression your provided: =Count({<InvoiceDate={"=InvoiceDate = JobOpenDate"}>} VehicleNo)

Re: Set analysis -Same date expression

Tue, 05 May 2015 12:48:49 GMT

Hi Shanmuga,

not sure what your model looks like, but if at all possible I would do this comparison in the script and create yourself a flag to use in set analysis instead.

e.g

If(Invoicedate =Jobopendate,1) As Invoice_Open_MatchFlag

then in your expression

Count( <{Invoice_Open_MatchFlag={1}>} VehicleNo)

hope that helps

Joe