Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm new to Qlikview so this might be easy.
I have a set of data the includes several KPIs for several companies per month. Below is a simplified example showing 3 KPIs for 2 companies in 2 months.
I want to add a 'Total' column to show the total value of a KPI for all companies in a certain month.
For example: in April both companies had a revenue of 1; so the total column should equal 2 for all rows that have:
Similarly, the total column would equal:
I used the method described in this thread https://community.qlik.com/t5/New-to-QlikView/Load-Script-Add-a-total-column/m-p/503083 but that just gave me a total of all KPI for all companies in all months.
Any help is appreciated. Thanks in advance.
Please check the attached
Thank you for replying. I've attached an excel sheet with the sample data and below is a simplification of my script
Table1:
LOAD Month,
Company,
KPI,
Data
FROM
Sample.xlsx
(ooxml, embedded labels);
Join (Table1)
Load
sum(Data)
Resident Table1
Please check the attached
Try this
Table1: LOAD Month, Company, KPI, Data FROM Sample.xlsx (ooxml, embedded labels); Join (Table1) LOAD Month, KPI, Sum(Data) as Total Resident Table1 Group By Month, KPI;
or try this in the front end as an expression
Sum(TOTAL <Month, KPI> Data)
Thank you all.