Hi, I have created a table and I wish to get the total %. In Excel, the total % for the week is 6% - see below. However, in Qlik it shows as - when I use Auto in the Totals function. When I use Avg in the Totals function, I get 8%. How can I get it to show 6%?
| |
|
|
EXCEL |
|
|
|
QLIK |
|
| |
Customers |
No Access |
% |
|
Customers |
No Access |
% |
|
| Total |
3440 |
214 |
6% |
|
3440 |
214 |
8% |
- |
| |
|
|
|
|
|
|
AVG |
AUTO
|
| 2022-11-28 |
741 |
55 |
7% |
|
741 |
55 |
7% |
|
| 2022-11-29 |
660 |
37 |
6% |
|
660 |
37 |
6% |
|
| 2022-11-30 |
589 |
50 |
8% |
|
589 |
50 |
8% |
|
| 2022-12-01 |
701 |
31 |
4% |
|
701 |
31 |
4% |
|
| 2022-12-02 |
680 |
37 |
5% |
|
680 |
37 |
5% |
|
| 2022-12-03 |
64 |
3 |
5% |
|
64 |
3 |
5% |
|
| 2022-12-04 |
5 |
1 |
20% |
|
5 |
1 |
20% |
|
Customers = if(count(Distinct{<JobType={'E','G'},[QLIK_Jobs.Client]={'XXXX'}>}if([PlannedDate.autoCalendar.Date]<Today(),[JobID-Jobid]))>0,count(Distinct{<JobType={'E','G'},[QLIK_Jobs.Client]={'XXXX'}>}if([PlannedDate.autoCalendar.Date]<Today(),[JobID-Jobid])))
No Access =if([PlannedDate.autoCalendar.Date]<Today(),count({<AbortCancelReason={"05*","06*"},JobType={'E','G'}>}AbortCancelReason))
% = No Access / Customers
