topic Re: Question on set analysis in QlikView

Question on set analysis

Wed, 15 Jul 2015 12:17:26 GMT

Hi Guys,

I have a bar chart with year as dimension and sales as expression. The year column contains the value form 2000 to 2010.

Suppose i want to see the informatin between 2000 and 2005. can you please let me know how to use between operator.

Regards,

Viresh

MayilVahanan — Wed, 15 Jul 2015 12:20:16 GMT

Try like this

= Sum({<Year = {">=2000<=2005"}>}Sales)

Wed, 15 Jul 2015 12:23:41 GMT

Hi Ramasamy,

its working fine, thank you.

qlikmsg4u — Wed, 15 Jul 2015 12:25:12 GMT

Hi Viresh,

Find the attached example and look at the following discussions.

MK_QSL — Wed, 15 Jul 2015 12:25:29 GMT

SUM({<Year = {">=2000<=2005"}>}Sales)

If you want Last 5 years from today

SUM({<Year = {">=$(=Year(Today())-4)<=$(=Year(Today()))"}>}Sales)

If you want Last 5 years from Selected Year

SUM({<Year = {">=$(=Max(Year)-4)<=$(=Max(Year))"}>}Sales)

If you want that any other selection i.e. Month, Quarter, Date should not affect your end result, you need to bypass them as below

SUM({<Date=, Week=, Month=, Quarter=, Year = {">=2000<=2005"}>}Sales)

Wed, 15 Jul 2015 12:31:16 GMT

thank you!!!

MK_QSL — Wed, 15 Jul 2015 12:38:44 GMT

Please close thread by selecting appropriate answer

qlikviewwizard — Wed, 15 Jul 2015 13:07:33 GMT

Good info

qlikviewwizard — Wed, 15 Jul 2015 13:10:07 GMT

Please close the thread by selecting Correct Answer.