Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

What is Setanalysis in Qlikview

Hi All,

Please help

7 Replies
pooja_prabhu_n
Creator III
Creator III

Hi,

Refer this

Set Analysis

Thanks,

Pooja

arvind1494
Specialist
Specialist

Hi King Aretha,

If you are new to qlik technology then

You can refer www.help.qlik.com

All topics are covered very well by qliktech.

qlikviewwizard
Master II
Master II

Hi,

This is simple example and you will get clear understanding by reading and understanding.

A Primer on Set Analysis

Qlikview/Qliksense works based on the selections done, for example let us assume in a Sales Dashboard we have a year field with 2012, 2103, 2014, 2015 and 2016.  If you select 2016 then all the charts will display sales for 2016, sometimes we need to override this.  For example sales last 5 years from selected year then we have to override the selections by using the set analysis expression like below

=Sum({<Year={'>=$(=Max(Year) - 4)<=$(=Max(Year))'}>} Sales)

You can find some sample expressions from below link


Set Analysis for certain Point in Time


Set Analysis for Rolling Periods

qlikviewwizard
Master II
Master II

Please read this doc. You will get A to Z about Set Analysis.

Set Analysis: syntaxes, examples

sujan24s
Contributor III
Contributor III

Set Analysis Wizard for QlikView | qlikblog.at

balabhaskarqlik

Close your thread, if you got the answer.