Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pradnya_amol
Creator
Creator

Need help in Set Analysis with based on 2 measures or using AGGR()

Hi All,

Using this formula to get distinct Report IDs in the below table:-

4 : Distinct Report IDs Count: Count(Distinct [Report ID])

1: Distinct Report ID using this Formula: Count(distinct [Report ID]) - Count(distinct{<[Receipts Reviewed]={'Y'}>} [Report ID])

1652 : Expense Amount: Sum([Expense_reimbursement _USD])

540: Requirement: Sum( aggr((Count(distinct [Report ID]) - Count(distinct{<[Receipts Reviewed]={'Y'}>} [Report ID])), [Expense_reimbursement _USD]))  but m getting 90. Please help in creating this formula using either SET analysis or AGGR()

ApproverDistinct Report IDsDistinct Reports using Main FormulaExpense Amount
Pradnya 41$1652

 

0 Replies