topic Re: excluded formula in set analysis in QlikView

excluded formula in set analysis

Anonymous — Wed, 10 Dec 2014 12:03:33 GMT

hi..

I have two formulas

first formula is:

num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS),'#,##0')

seconded formula is:

num(count({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS),'#,##0')

now i am trying to excluded second formula from first formula

num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'},acdunicaall=e(only({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS))>} distinct ACD_UNIQUECALLS),'#,##0')

but its not working properly..

can you please help me..

Thanks,

Re: excluded formula in set analysis

rubenmarin — Wed, 10 Dec 2014 12:46:55 GMT

Hi Chandini, you can do a substract?:

num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)

- count({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)

,'#,##0')

Anyway, I don't thinh e(only(.. will work, as Only() returns one value and the expression inside returns multiple values, maybe:

num(count({<PeripheralCallType = {'2'},AgentSkillTargetID={"*"},TimeToAband ={'>0'},acdunicaall=e({<PeripheralCallType = {'1'},TimeToAband ={'>0'}>} distinct ACD_UNIQUECALLS)>} distinct ACD_UNIQUECALLS),'#,##0')