Using selection(s) in Expression

Thu, 06 Jun 2013 23:43:12 GMT

I have a chart that shows statuses of loan applications. For each status, I would like to show the percentage of that status vs. the total # of apps.

I've tried with nested ifs:

if(if(CUDCDATA.DECISIONTYPE='Approved',count(CUDCDATA.DECISIONTYPE)/count([CUDC APPID])),

if((CUDCDATA.DECISIONTYPE='Approved w/Condtions'),count(CUDCDATA.DECISIONTYPE)/count([CUDC APPID])))

and also:

count(DISTINCT(CUDCDATA.DECISIONTYPE))/Count(CUDCDATA.DECISIONTYPE)

topic Using selection(s) in Expression in QlikView