I'm loading in multiple spreadsheet all in a crosstab format, which is working fine, but when I want to do an expression on the 'Data' (typically 'Sum (Data)' in a chart) it is coming up with with the error message 'You have attempted to apply a numerical expression, which is not uniquely defined for the specified variable. In order to use this variable in expressions relying on number of occurences, please read it a second time under a new name from its primary table'
I understand from this I need to load 'Data' in twice, as Data has formed a key, and that means it won't calculate, but as its not actually source in the primary table, I'm not sure how to do it. I've tried putting in the crosstab field twice (e.g. in red in the code below) but in that instance only Datacalc loaded. I can't Load Data from the source data as it doesn't work.
Thanks for your patience on this Qlikview newbie! I've tried recreating the problem with sample data for upload, but I can't get it recreate the problem. I'm happy to upload my existing file if I can then delete it from the thread once the problem is fixed - do you know if thats possible?
As I understand the problem, QV is creating a field 'Data' from my cross tab files in excel (actually five spreadsheets, each with multiple sheets, I think this might be relevant as it didn't cause problems when it wasn't this complex in the sample versions I was getting out).
QV makes the Data a KEY field as its common across all spreadsheets
I would like to make the Data the subject of an expression, but QV won't let me do this unless I load Data in again as a new field with a different name from the primary data. But as it doesn't exist in the primary data (QV has calculated it from the cross tab format) it doesn't work...
If you can't help, really no problems, we've got suppliers who should be able to help later in the week... just wanted to see if I could fix the problem myself.