topic Re: Problem in percentage share on selection in QlikView

Problem in percentage share on selection

Fri, 29 Jan 2016 10:08:50 GMT

Hi community,

I have a chart with shows customer wise balances. Customer is taken as dimension where as I have written set analysis in expression to show balances. I created another expression with same set analysis and checked on 'relative' box, this shows me the percentage share of each customer, like this I have three columns

1.Customer

2. Balance

3. Percent Share

Without selection it works fine, but when ever I select a customer, the percentage shows 100%, however what I am trying to achieve is upon selection of any customer the percentage should show the percent share of that customer in total portfolio.

My expression is

=(num(NUM(sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000,'#,##0')

NUM(fabs((sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},FLAG = {'CORP'}>}BALANCE_CPS_FULL)))/1000000,'#,##0'),'#,##0'))

Any proposed solution?

Thank you very much,

Usama

Re: Problem in percentage share on selection

settu_periasamy — Fri, 29 Jan 2016 16:45:28 GMT

Hi,

Relative % will work based on your display value..

may be try somethng like

=Num(((sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},

FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000)+

(sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},

FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000))

((sum({1<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},

FLAG = {'CORP'}>}TOTAL BALANCE_CPS_FULL)/1000000)+

(sum({1<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},

FLAG = {'CORP'}>}TOTAL BALANCE_CPS_FULL)/1000000)),'#,##0.00%')

sample attached

Re: Problem in percentage share on selection

Mon, 01 Feb 2016 04:58:56 GMT

Thank You very much. You solution works fine.