Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in set Analyse

Can someone please tell me whats wrong in this syntax?

count

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)


View solution in original post

2 Replies
swuehl
MVP
MVP

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)


Not applicable
Author

Thank u exactly what I wanted.

Håkan