Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

Set analysis question

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

1 Solution

Accepted Solutions
stabben23
Partner - Master
Partner - Master

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)

View solution in original post

9 Replies
dsharmaqv
Creator III
Creator III

can you please post oyur app

jduluc12
Creator
Creator
Author

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

stabben23
Partner - Master
Partner - Master

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)

Anonymous
Not applicable

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=

jduluc12
Creator
Creator
Author

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

flipside
Partner - Specialist II
Partner - Specialist II

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

dsharmaqv
Creator III
Creator III

try by removing this Year=, Month=,

jduluc12
Creator
Creator
Author

Hey

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

Thank you

jduluc12
Creator
Creator
Author

yes that was also a problem.

Thanks.