Just this one but even if I comment it out it will not work. I don't see why I wouldn't be able to have report date in both tables. I want one filter for report date that will affect my charts for each table.
SQL SELECT ReportDate [Report Date],
STORE CollectionEffectivness into [lib://QVD/CollectionEffectivness.qvd](qvd);
Drop Table CollectionEffectivness;
I was looking at the log file and was about to attach it when I saw the issue. Qlik Sense is not recognizing the numbers at the beginning of the fields as part of the field name. See below. Wrapping the fields that begin with a number in [ ] solved the issue.
"11 fields found: ReportDate, ReceiptStatus, ReceiptType, DayCnt, DayAmt, DayCnt,"
**EDIT: for anyone that might find this useful later, it is actually SQL returning the column names without the numbers in the front so Qlik Sense then thinks they are named the same.**