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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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