Discussion board where members can get started with Qlik Sense.
I am wondering, can the join prefix be used in combination with the Crosstable prefix?
[Q2 Project Budget]:
CROSSTABLE ([Date],[Project Budget Amount],1)
LOAD [Project Budget] as [Item],
When I load this I get the following error: 'Illegal combination of prefixes'
Go to Solution.
This is not possible, however you can do this
LEFT JOIN (TableName)
Resident [Q2 Project Budget];
DROP Table [Q2 Project Budget];
While you are doing this, might as well fix the dates also
Date(Num#(Date)) as Date,
[Project Budget Amount]
I am trying to join Q2 Project Budget to a table called Q1 Project Budget. As such the script reads:
LEFT JOIN ([Q1 Project Budget])
When I load that I get this error: Illegal combination of prefixes
Why is this?
Screenshot of the error message?
Hahahaha did you forget to remove Left Join on top of CrossTable? or was this to test me
Sorry yeah I was being foolish. When I start asking other to help I don't stop to look at it carefully myself. Thank you for your help.