Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help
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.
Hi,
This is simple example and you will get clear understanding by reading and understanding.
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
Please read this doc. You will get A to Z about Set Analysis.
Set Analysis Wizard for QlikView | qlikblog.at
Close your thread, if you got the answer.