topic Re: What is Setanalysis in Qlikview in QlikView

What is Setanalysis in Qlikview

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help

Re: What is Setanalysis in Qlikview

pooja_prabhu_n — Wed, 01 Aug 2018 11:30:36 GMT

Hi,

Refer this

Set Analysis

Thanks,

Pooja

Re: What is Setanalysis in Qlikview

arvind1494 — Wed, 01 Aug 2018 11:30:42 GMT

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.

Re: What is Setanalysis in Qlikview

qlikviewwizard — Fri, 03 Aug 2018 04:20:00 GMT

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

Re: What is Setanalysis in Qlikview

qlikviewwizard — Fri, 03 Aug 2018 04:21:22 GMT

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

Set Analysis: syntaxes, examples

Re: What is Setanalysis in Qlikview

sujan24s — Fri, 03 Aug 2018 06:13:53 GMT

Set Analysis Wizard for QlikView | qlikblog.at

Re: What is Setanalysis in Qlikview

BalaBhaskar_Qlik — Fri, 03 Aug 2018 06:46:13 GMT

Check these:

https://www.youtube.com/watch?v=YMQJnKMkfxg

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Re: What is Setanalysis in Qlikview

BalaBhaskar_Qlik — Sat, 25 Aug 2018 15:19:53 GMT

Close your thread, if you got the answer.