Need help with Expression

[HimanshuKakade]

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.

[Taoufiq_Zarra · Accepted solution]

@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 :