Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am having trouble with this expression:
[CSL Account Name],
Sum(Num([CSL Total Annual Revenue])) as [CSL Sum Total Revenue]
Group By [%CSLGranteeExternalID],[CSL Account Name];
It will not load, please let me know what you think could be the problem. I keep getting the error "Invalid Expression" when I run the script.
did you tried without num and reload?
Sum([CSL Total Annual Revenue]) as [CSL Sum Total Revenue]
I tried both and still recieving the same error message.
can you paste your full script ?
May be can you try like this:
[CSL Total Annual Revenue],
Num(Sum([CSL Total Annual Revenue]),'##,#.00') as [CSL Sum Total Revenue]
Group By [%CSLGranteeExternalID];
Drop table Account;
You could check all the field names of Temp_Sum, matched correctly with Account table.
Or else, could you provide some more script to identify the issue.
Hi, I actually ended up changing the script quite a bit, here is the new script I'm working on, but still haven't been able to get it working:
[CSL Account ID],
//[CSL Account Name],
if([CSL Rev by Funder]>20000,[CSL Account Name], 'All Other Grantees') as [CSL Account Name],
[CSL Account Type],
[CSL Total Annual Regranting],
[CSL Org Mission],
[CSL Year of Data],
[CSL No of Employees],
[RCF as Funder];
Sum([CSL Total Annual Revenue]) as [CSL Rev by Funder]
Group by %CSLGrantorExternalID;
Drop table AllOrgs_TempGrantee;
Where is this: AllOrgs_TempGrantee table?
May be you can try like this:
[RCF] as Funder;
Group by %CSLGrantorExternalID,[CSL Account Type];
Drop table AllOrgs;
Try this 3 and see if that helps:
-try adding all fields in the group by except the aggregating field and then do a resident load of that in a different table
- Try converting the format of the measure in 1st table check in UI and then try aggregate it by resident load .
-try other aggregate functions with 1 field like max and continue adding other fields if it works then you can replace it by Sum