Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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