Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Question on set analysis

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

Tags (1)
8 Replies
mayilvahanan
Not applicable

Re: Question on set analysis

Hi

Try like this

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

Not applicable

Re: Question on set analysis

Hi Ramasamy,

its working fine, thank you.

qlikmsg4u
Not applicable

Re: Question on set analysis

Hi Viresh,

Find the attached example and look at the following discussions.

Set Analysis: syntaxes, examples

Learning Set Analysis from Scratch

MK_QSL
Not applicable

Re: Question on set analysis

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)

Not applicable

Re: Question on set analysis

thank you!!!

MK_QSL
Not applicable

Re: Question on set analysis

Please close thread by selecting appropriate answer

Arjunarao
Not applicable

Re: Question on set analysis


MRKachhiaIMP

Good info

Arjunarao
Not applicable

Re: Question on set analysis

kolagima

Please close the thread by selecting Correct Answer.