Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am unable to achieve correct Pivot Table total in Qliksense November 2020 version. Below is how the table looks :
May | Jun | Jul | Augu | Sep | ||
Company name | ID | |||||
OOPA | 3456 | 3.75 | ||||
FEDA | 2314 | 2 | 1 | 0.25 | ||
RATE | 5678 | 2 | 3.75 | |||
NOVA | 4671 | 2 | ||||
Total | 2 | 3 | 3.75 | 2 | 4 |
Dimension - Company name, ID and month
Expression - sum(aggr(rangemin(count(id)-rangesum(before(column(1),1,columnno(Total), count(id)/4)
This expression changes the total for certain columns for eg : Nova for June is 2 but shows total as 3. With aggr function row level values also changes for some months. eg actual value for FEBA is 3 but it is showing 1 for June. Expected output of this table is
May | Jun | Jul | Augu | Sep | |
Company name | |||||
OOPA | 3.75 | ||||
FEDA | 2 | 3 | 0.25 | ||
RATE | 2 | 3.75 | |||
NOVA | 2 | ||||
Total | 2 | 5 | 3.75 | 2 | 4 |
Any help would be appreciated.
@tellmalaika17 share sample data with expected output
Attached is the sample data and the expected output is in sheet summary.
Did you have any luck with the issue?