topic Re: Set analysis question in QlikView

Set analysis question

jduluc12 — Tue, 14 Mar 2017 12:41:35 GMT

HI,

I have an expression

=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)

and i got filters for year and month and my expectation is if I select the year 2015 and month May then I should see the chart with only data from 01/01/2015 to 05/31/2015 but it even shows the data from Dec, 2014.

What am i missing here?

Thanks,

jean

Re: Set analysis question

dsharmaqv — Tue, 14 Mar 2017 12:49:52 GMT

can you please post oyur app

Re: Set analysis question

jduluc12 — Tue, 14 Mar 2017 13:03:17 GMT

Hi Deepak,

It would be difficult for me to post app because it got a lot of sensitive data.

Can you figure out any issue by just looking at the expression? Shouldn't it work as i am expecting?

have i used Year=, Month=, correctly?

Thanks

Re: Set analysis question

stabben23 — Tue, 14 Mar 2017 13:11:27 GMT

Hi,

I'll think you now only find this part "<=$(=max(Date)", try to add a $ and a = here:

sum({<Date={">=$(=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)

Re: Set analysis question

Anonymous — Tue, 14 Mar 2017 13:18:15 GMT

Have you tried without this part: Year=, Month=

=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}>} Amount)

Qv will ignore Year and month selections because of this Year=, Month=

Re: Set analysis question

jduluc12 — Tue, 14 Mar 2017 13:18:53 GMT

ok...the $ sign was there and i had missed the "=" so it added but it still brings from 2014.

Re: Set analysis question

flipside — Tue, 14 Mar 2017 13:23:01 GMT

You have an extra closing bracket in the YearStart expression, I think.

Re: Set analysis question

dsharmaqv — Tue, 14 Mar 2017 13:23:38 GMT

try by removing this Year=, Month=,

Re: Set analysis question

jduluc12 — Tue, 14 Mar 2017 13:28:26 GMT

Hey

it worked...i think the problem was missing "="..

Thank you

Re: Set analysis question

jduluc12 — Tue, 14 Mar 2017 13:28:54 GMT

yes that was also a problem.

Thanks.