Qlik Community

New to Qlik Sense

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

Tell us which business and trade publications you read most regularly: RESPOND NOW
Showing results for 
Search instead for 
Did you mean: 

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


Labels (4)
0 Replies