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: 
amber2000
Creator
Creator

Error in Expression when using MasterCalendar


Hello everyone,

I'm strugling with my MasterCalendar, when I do a reload I'm getting :

Error in Espression ')' Expected

I can't find where the error occurs.

Does anybody know why please?

12 Replies
amber2000
Creator
Creator
Author

Sorry I've given the wrong Field name, it should be DT_Create_Dates (SD_Close_Date is from another table),

and as you show in table view this field is linked. Still it isn't showing the dates if I select month

jpenuliar
Partner - Specialist III
Partner - Specialist III

try to remove month filter/listbox and add again,

I am not sure what is happening here, but It worked that way on my end

amber2000
Creator
Creator
Author

Dear Jonathan,

This is not working for me, but there’s something strange on the table view: The subset ratio is 50% on both tables for field DT_Create_Dates.

So I looked at the script and removed the date format from //DATE#(TempDate, 'YYYYMMDD') as DT_Create_Dates,

to TempDate AS DT_Create_Dates and after the reload the problem was fixed.

Thank you so much for helping me.

Kind regards,

Ambertje