HI Team,
Pivot Table is showing the data in qliksense in all the cells it is showing zero values please find the attachment for refernece also find the KPI Formula below
Formula:
num(sum(aggr(max({$<[Service Type]={'S01'},[C Code]-={'ZY'},[R Ticket num]={0}>}[RC Days]),[Ticket ID]))
/(count(distinct{$<[ Service Type]={'S01'},[C Code]={'Z1','Z2'},[ZCSRQ_TID__ZUPDATE]-={'Y'},[Re Ticket num]={0}>}[Ticket ID])),'##.##')