topic Re: Need Only selected year to show up in QlikView

Need Only selected year to show up

Wed, 21 Jan 2015 20:34:48 GMT

I need (through set analysis) to show selected years or months on this chart depending what the user selects:

for example, when they select a year of 2014, I would only like the red line to show up. if they pick two months (i.e. Jan-Feb), along with 2014, I want to see the red line only for those two months.

The equations I have right now for the three expressions are as follows in descending order of year:

sum({$<Year= {$(=Year(Today()))}>} MembershipFlag)
sum({$<Year= {$(=Year(Today())-1)}>} MembershipFlag)
sum({$<Year= {$(=Year(Today())-2)}>} MembershipFlag)

Any help on this is greatly appreciated.

Thanks,

Joe

Re: Need Only selected year to show up

Anonymous — Wed, 21 Jan 2015 20:44:39 GMT

Joe,

Looks like you want chart to behave according to selections. Set analysis is needed when you want to override selections. So, in you case set analysis is not needed. Instead, add Year as a dimension to your chart, and expression will be

sum(MembershipFlag)

Regards,

Michael

Re: Need Only selected year to show up

Wed, 21 Jan 2015 21:33:46 GMT

Amazing, thank you. However, I need to push out reports of this chart from a month ago. For example, I want to show the last 2 years on that report with only January selected slated out the 1st of February. Does that make sense?

Thanks,

Joe

Re: Need Only selected year to show up

Wed, 21 Jan 2015 22:15:14 GMT

Do you just mean January for each of the two years? Or 1 full year and just january from the other?

If it's the first you should just be able to select the years and month you want.

If it's the latter, you might need to use a year&month concatenated field and select within that, to be able to select all of 2013 for example and then just January 2014

hope that helps

Joe

Re: Need Only selected year to show up

Wed, 21 Jan 2015 22:16:21 GMT

Yup! Makes sense to me. Thank you.

Re: Need Only selected year to show up

Wed, 21 Jan 2015 22:23:16 GMT

no problem glad to help, also great name

Re: Need Only selected year to show up

Wed, 21 Jan 2015 22:24:23 GMT

Hah! Same to you... though your last name needs some work