topic Re: Set Analysis Variables in QlikView

Set Analysis Variables

Fri, 05 Feb 2016 10:43:02 GMT

Hello i am struggling with an expression.I have two variables below.

vWeekStartCY = date(date(WeekEnd(MakeWeekDate(year(today()),num(right([Year Week],2),00)-1)))+1)

vWeekEndCY = date(WeekEnd(MakeWeekDate(year(today()),right([Year Week],2))))

Final Statement

=count({<cus_StartDatum = {">=$(vWeekStartCY)<= $(vWeekEndCY"},
bu3_Market=>} distinct TP_ID)

However the result is 0.

this should not be the case , a helpy hint with my set analysis is much appreicated.

Best

/Brad

MK_QSL — Fri, 05 Feb 2016 10:45:01 GMT

Try

=count({<cus_StartDatum = {">=$(=vWeekStartCY)<= $(=vWeekEndCY"},
bu3_Market=>} distinct TP_ID)

Fri, 05 Feb 2016 10:46:55 GMT

still not working but thank you for replying

MK_QSL — Fri, 05 Feb 2016 10:52:28 GMT

Create two text boxes and use below expressions and let us know the result you are getting...

=$(vWeekStartCY)

=$(vWeekEndCY)

Also provide format of cus_StartDatum

tresB — Fri, 05 Feb 2016 10:54:40 GMT

Check how the values are coming in variables, are they of similar formats to the dates in field cus_StartDatum ?

mightyqlikers — Fri, 05 Feb 2016 11:00:19 GMT

what you want to get in the two variables .

vWeekStartCY

vWeekEndCY

try to display those values in textboxes then try in set analysis

Regards

$@M.

Fri, 05 Feb 2016 12:08:00 GMT

Yes they are in the correct format all of them.

YYYY-MM-DD