topic Re: edit bug in set expression in QlikView

edit bug in set expression

pratap6699 — Sun, 26 Apr 2015 13:06:05 GMT

sum({<year={"(='>='&year) & ='<='&Max(year-2)"}>}spent)

i want to show greater than selected year and less than max(year-2) result...my condition is correct but i didn't get any result please help me

Anonymous — Sun, 26 Apr 2015 13:21:18 GMT

I made a few fixes, try it:

sum({<year={"$(= '>=' & year & '<=' & Max(year)-2)"}>} spent)

pratap6699 — Sun, 26 Apr 2015 13:46:33 GMT

HAI THANKS FOR RESPONCE MR MICHEL BUT ITS NOT WORKING.... IT NOTHING SHOW IN CHART

sunny_talwar — Sun, 26 Apr 2015 13:52:36 GMT

I don't know if adding a max to first year will make a difference or not, but try this (further editing Michael Solomovich‌ suggestion)

sum({<year = {"$(= '>=' & Max(year) & '<=' & Max(year)-2)"}>} spent)

Best,

Sunny

maxgro — Sun, 26 Apr 2015 14:09:31 GMT

don't know if I understand

y= year

v=spent

>= selected year or <= selected year -2

sum({$ <y={">=$(=max(y))"}>+<y={"<=$(=max(y)-2)"}> } v)

>= selected year and <= selected year -2 (always 0)

sum({$ <y={">=$(=max(y))"}>*<y={"<=$(=max(y)-2)"}> } v)

between year-2 and year

sum({$ <y={">=$(=max(y)-2)<=$(=max(y))"}>} v)

Anonymous — Sun, 26 Apr 2015 14:16:50 GMT

Good point

Sales in >= 2015 and <=2013 can only return 0

pratap6699 — Sun, 26 Apr 2015 15:13:58 GMT

see the result it is also no working