My Qlikview document loads in an Excel table similar to the one below:
LOAD Rec_Ref, Rep_Date, [Audit Recommendations], Rec_Ranking, Systemic, [Audit Report Name], Division, [Function Responsible], [Location / Region], [Assistant Head Responsible], Email, [Report Owner], Email1, [Contact Tel. No.], Status, [Date Rec Updated], [Update on Recommendation], [Update on Report], [Update on Year], [Movement from previous IA Report], [Report to be Re-assigned], [Recommendation with another Division], [Report included in Internal Audit Division Report], [Type of Audit Report], CompTot, If([Rec_Ranking]='H','1.H',if([Rec_Ranking]='M','2.M','3.L')) as [Rec_Rank_Ref], if([Status]<>'Implemented/Superceded',1,0) as [O/S Rec Num], if([Status]<>'Implemented/Superceded','Y','N') as [O/S Rec]
FROM [audit recs.xlsx] (ooxml, embedded labels, table is [Compdatabase]);
I was looking to add the following to the script:
LOAD Status, SUM(CompTot) as CompTot GROUP By CompTot;
SQL SELECT Status,
CompTot [audit recs.xlsx] (ooxml, embedded labels, table is [Compdatabase]);
But it was giving me a Syntax error related to the SQL Select (I think).
Ultimately I want to show these 3 KPIs (possibly) as a Text Object in the dashboard.
But I also need the '400' to be unaffected by Current Selections.
Therefore I was going to use the CompTot field to sum to 400. Assign that to every record then get an Average of all the records which will mean it will always remain as 400 no matter the Current Selection.