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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the column by Calculation.

Hi

I want to show the Dept by the below condition.

my condition is show Department which have more than 60% of employee compare to Vendor. Here I attached Source file for your reference...

And please tell me if it is not possible means....

Thanks in Advance

10 Replies
alibd225
Creator
Creator

1.  =if(Vendor/Employee*100>60,Dept) in dimension

2. Check mark when Value is null

3. write expression =Vendor/Employee

4, show number tab and set show in percentage