Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

How to obtain correct result of a %

Hi,

I am trying to obtain a percentage of a monthly data. The correct results should be obtained from 2 different tables.

To do that I used the following Expression:

count({$<[TO_Employee/CW_Type]={"Regular"},TO_RATE_1_or_2={"Yes"},[TO_Voluntary/Involuntary_Terminations]={"Voluntary"}>}TO_Employee_ID)

/

count({$<HC_Employee\CW_Type={"Regular"},HC_RATE_1_or_2={"Yes"}>}HC_Employee_ID)

If I used the dimension from The first Table I got On result, If I used the dimension from the second table I obtain another result.

Basically when using the first dimension It counts the correct data, based on the first expression, but the second expression counts all data as a single number for every month.

How can I do so each of the expressions counts based on different dimensions?

Or Is It possible to use some sort of conditional dimension like if I user the first expression use one dimension dimension and when using the second expression use the other dimension?

Regards,

0 Replies