Question on set analysis

[#1]

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]

Hi

Try like this

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

[#3]

Hi Ramasamy,

its working fine, thank you.

[qlikmsg4u]

Hi Viresh,

Find the attached example and look at the following discussions.

Set Analysis: syntaxes, examples

Learning Set Analysis from Scratch

[MK_QSL]

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)

[#6]

thank you!!!

[MK_QSL]

Please close thread by selecting appropriate answer

[qlikviewwizard]

MRKachhiaIMP‌

Good info

[qlikviewwizard]

kolagima

Please close the thread by selecting Correct Answer.