topic Re: Need help with Expression in QlikView

Need help with Expression

HimanshuKakade — Thu, 02 Jul 2020 11:01:17 GMT

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

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 — Thu, 02 Jul 2020 11:46:03 GMT

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 :