topic Re: SET Analysis How to set date greater then 2016 ? in QlikView

SET Analysis How to set date greater then 2016 ?

paulyeo11 — Mon, 12 Feb 2018 08:59:46 GMT

Below expression work fine for year= 2016 :-

Sum({<year={2016},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) <= 8"}>} sales)

I need to change the above expression for year 2016 2017 2018 . which is > 2016.

I try below , but cannot work :-

Sum({<year={">2016"},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"}>} sales)) <= 8"}>} sales)

Sum({<year>={2016},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year >= {2016}>} sales)) <= 8"}>} sales)

Hope some one can share with me.

Paul Yeo

Re: SET Analysis How to set date greater then 2016 ?

tresB — Mon, 12 Feb 2018 09:08:07 GMT

Ideally your first expression :

Sum({<year={">2016"},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"}>} sales)) <= 8"}>} sales)

should work. However, if you have some other fields that has selections too can cause this not work. Then you could try by passing those fields selections like:

Sum({<year={">2016"},Quarter,Month,Date,REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"},Quarter,Month,Date>} sales)) <= 8"}>} sales)

Update: corrected a comma

Re: SET Analysis How to set date greater then 2016 ?

paulyeo11 — Mon, 12 Feb 2018 09:22:21 GMT

Hi Tres

Thank you for your help. I have try but still not working.

Paul Yeo

Re: SET Analysis How to set date greater then 2016 ?

MK_QSL — Mon, 12 Feb 2018 09:30:41 GMT

I can see that in enclosed file you have only 2016 data for year field.

Re: SET Analysis How to set date greater then 2016 ?

tresB — Mon, 12 Feb 2018 09:34:09 GMT

Try correcting two quotes and a comma like:

Sum({<year={">2016"},Quarter,Month,Date,REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {[>2016]},Quarter,Month,Date>} sales)) <= 8"}>} sales)

I could not validate since your sample app doesn't have data beyond 2016.

Re: SET Analysis How to set date greater then 2016 ?

paulyeo11 — Mon, 12 Feb 2018 09:36:44 GMT

Thank you very much , it work now.

Re: SET Analysis How to set date greater then 2016 ?

jasonmomoa — Mon, 12 Feb 2018 12:31:17 GMT

Hi paulyeo11‌,

your first attemp should work:

Sum({<year={">2016"},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"}>} sales)) <= 8"}>} sales)

Make sure you have [Year] values greater than 2016.

Regards,

Re: SET Analysis How to set date greater then 2016 ?

paulyeo11 — Mon, 12 Feb 2018 16:46:33 GMT

Hi Xavier

May I know how you know due to year or Year issue ? How you find out ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: SET Analysis How to set date greater then 2016 ?

jasonmomoa — Mon, 12 Feb 2018 17:06:50 GMT

Hi paulyeo11‌,

I downloaded your Ask.qvf file. In there, you only have 1 value for year (=2016). Therefore, ever since you write the expression

Sum({<year={">2016"},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"}>} sales)) <= 8"}>} sales),

there is no year> 2016, neither Companies ranked the 8th.

If you can load more data for future years, then the expression would work.

Hope this helps.

Regards,