Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MB7
Contributor
Contributor

Load script or expression

Hello,

 

in app I want to show amount of insured accounts receivable, where  amount of accounts receivables exceeds insured amount.

 In my table I have insured amount for each company and amounts of accounts receivable as well - of course there could be multiple insert for each company (as export is done on invoice level)

 

If I show this in a table , everything is ok (as I have dimension Company), but I also want to show amount  in KPI report. The issue I'm facing is that if I want to show it in KPI report is that I need to define dimension (company ), which I do not want to have as I need only total amount.

 

If maybe someone has a solution?

Is it possible in KPI report to define Measure for Company and hide this dimension, as I need only total amount of the amounts exceeds Insurance


Thank you in advance

 

 

MB7_0-1675164385567.png

 

Labels (2)
1 Reply
ogster1974
Partner - Master II
Partner - Master II

Something like 

Sum(Aggr(Sum(TOTAL Amount), Company))

might work