Set Analysis - How to do a percentage comparison

carolinarodrigues — Fri, 30 Dec 2022 17:24:57 GMT

I have an expression with some criteria that is working just fine but it gets errors when I try to change the comparison to show the difference vs the previous year in percentage. What am I doing wrong?

Original expression is : (Count({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-22"}>}[Updated BU])/Count({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-21"}>}[Updated BU])-1)*100

I tried adding the % but I got an error.

num(Count(({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-22"}>}[Updated BU])/Count({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-21"}>}[Updated BU])),'#,##0%')

Any tip or suggestion will be appreciated as I am kinda confused at this point.

Re: Set Analysis - How to do a percentage comparison

rubenmarin — Sat, 31 Dec 2022 09:16:12 GMT

Hi, try setting the number format to your full current expresssion (only remove the *100):

Num((Count({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-22"}>}[Updated BU])/Count({<[Employee Type]={"Permanent"},[Status]={"Active","Leave of absence"},[Status],[Reporting Month]={"Dec-21"}>}[Updated BU])-1),'#,##0%')

topic Re: Set Analysis - How to do a percentage comparison in QlikView

Set Analysis - How to do a percentage comparison

Re: Set Analysis - How to do a percentage comparison