Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The issue appears to be that the second formula needs to be re-written with the if() contained within the count (the first formula appears to already have that in place), though it's hard to be sure given there's no sample data to check with.