topic Re: Error in set Analyse in QlikView

Error in set Analyse

Mon, 06 Aug 2012 10:07:39 GMT

Can someone please tell me whats wrong in this syntax?

count

({$< CheckinRank = {">=0"}, DepartureYear = {"=$(vLastYear)"}, WeekWeekDayNum = {"<$(vWeekWeekDay)"} >}
*
{$< CheckinRank = {">=0"}, DepartureYear = {"=$(vLastYear)"}, WeekWeekDayNum = {">=$(vLast3WeekWeekDay)"} >}
CFSKEYBook)

Re: Error in set Analyse

swuehl — Mon, 06 Aug 2012 10:24:21 GMT

I don't think using two set expressions within an aggregation function is valid syntax or works like expected. What do you want to achieve?

If you want to combine the limits for WeekWeekDayNum into one search expression, try:

count

(

{$< CheckinRank = {">=0"}, DepartureYear = {$(vLastYear)}, WeekWeekDayNum = {">=$(vLast3WeekWeekDay)<$(vWeekWeekDay)"} >}

CFSKEYBook)

Re: Error in set Analyse

Mon, 06 Aug 2012 10:49:28 GMT

Thank u exactly what I wanted.

Håkan