Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

@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
Highlighted
Master
Master

@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