Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Invalid expression

Can anyone see where my issue lies?

Concatenate(Weekly_Validations)

Load

  Complaints_Country_Code as [Country Code],

  text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))) as Fiscal_Year_Week,

  [Complaint Registered Date],

  null() as [Weekly_Date],

  'Complaints Registered' as Weekly_Control,

  sum([Case ID]) as [Weekly Record Count]

FROM

[$(vQVDs)\A_Complaint.qvd]

(qvd)

where exists([Fiscal_Year_Week],  text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))))

group by text(ApplyMap('MapDateToFiscalWeek', replace(WeekName([Complaint Registered Date]), '/', '-'))), Complaints_Country_Code

;

I keep getting Invalid Expression

1 Solution

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Add [Complaint Registered Date] to your group by

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

Add [Complaint Registered Date] to your group by

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!