Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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