topic Set analysis issue in QlikView

Set analysis issue

Anonymous — Tue, 15 Apr 2014 15:04:02 GMT

Hi guys,

I can't understand what wrong with my expression

Avg({<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception]) is?

Please see my attached file.

Thanks,

Re: Set analysis issue

richard_pearce6 — Tue, 15 Apr 2014 15:14:55 GMT

Try

avg ({<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))"},oDate={"<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])

Re: Set analysis issue

Tue, 15 Apr 2014 15:16:39 GMT

Try with this:

=Avg(DISTINCT {<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])

Re: Set analysis issue

its_anandrjs — Tue, 15 Apr 2014 15:23:20 GMT

I dont believe there is any error might be try like

=Avg({<oDate={">=$(=date(date#(vStart,'DD/MMM/YYYY')),'DD/MMM/YYYY')<=$(=date(date#(vEnd,'DD/MMM/YYYY')),'DD/MMM/YYYY')"}>} [Brand Perception])

or may be this

=Avg(DISTINCT {<oDate={">=$(=date(date#(vStart,'DD/MMM/YYYY')),'DD/MMM/YYYY')<=$(=date(date#(vEnd,'DD/MMM/YYYY')),'DD/MMM/YYYY')"}>} [Brand Perception])

Re: Set analysis issue

Tue, 15 Apr 2014 15:25:04 GMT

which is the expected result?

Re: Set analysis issue

Anonymous — Tue, 15 Apr 2014 20:27:48 GMT

The expression is correct, works fine as it is.

Not sure though what you're trying to do with it in your application. But this should be a different question.

Re: Set analysis issue

Anonymous — Tue, 15 Apr 2014 23:49:23 GMT

Sorry guys,

I found the problem. the expression is good.