Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
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])
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])
Hi Marcus,
Great solution, working perfect now as expected.
Thank you for your quick response 🙂
Thank you