How to Include all values of a column in a Set Analysis formula

[sarsukanth]

Hi All,

I have a query in Qlik Sense.

I need a table like below, but I am not getting the set analysis formula in the place of ? (question mark)

anyone please help me, let me know if any confusion.

Thank you

Date	=Count({<Status={'Passed'}, Cate={'Cat-A'}>}[Unique_EMP_Info])	?	=Count({<Status={'Passed'}, Cate={'Cat-A'}>}[Unique_EMP_Info]) / ?
07/10/2023	5	10	50%
07/31/2023	3	10	30%
09/07/2023	2	10	20%

[marcus_sommer · Accepted solution]

I assume you are looking for something like:

Count({<Status={'Passed'}, Cate={'Cat-A'}>} [Unique_EMP_Info]) /
Count({<Status={'Passed'}, Cate={'Cat-A'}>} TOTAL [Unique_EMP_Info])

[sarsukanth]

Hi Marcus,

Great solution, working perfect now as expected.
Thank you for your quick response 🙂

Thank you