Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
HimanshuKakade
Contributor
Contributor

Need help with Expression

Please refer the attachment.
We calculate 2 metrics
1) ROTCE = Net_Income/Total_TCE
2) RORC = Net_Income/Total_RC

We need to Count all the clients in 4 categories

  • Category 1 - ROTCE >= 50% AND RORC >= 50%
  • Category 2 - ROTCE >= 50% AND RORC < 50%
  • Category 3 - ROTCE < 50% AND RORC >= 50%
  • Category 4 - ROTCE < 50% AND RORC < 50%

and create a Pie Chart or Mecco chart showing Total Clients count by Category.

Please guide us on how to create an expression.

1 Solution

Accepted Solutions
Taoufiq_Zarra

@HimanshuKakade 

attached Qlikview one solution :

ROTCE

sum({<MetricDesc={'Net_Income'}>} Value)/sum({<MetricDesc={'Total_TCE'}>} Value)

RORC

sum({<MetricDesc={'Net_Income'}>} Value)/sum({<MetricDesc={'Total_RC'}>} Value)

 

and the pie chart

output :

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@HimanshuKakade 

attached Qlikview one solution :

ROTCE

sum({<MetricDesc={'Net_Income'}>} Value)/sum({<MetricDesc={'Total_TCE'}>} Value)

RORC

sum({<MetricDesc={'Net_Income'}>} Value)/sum({<MetricDesc={'Total_RC'}>} Value)

 

and the pie chart

output :

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉