Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Contributor

Re: Show the column by Calculation.

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

and check suppress when value is null

and demp.png

Not applicable

Re: Show the column by Calculation.

ji that is not working

Not applicable

Re: Show the column by Calculation.

In the expression tab - on the column you need, check the Conditional check box so it's not greyed out, then enter your expression for Dept/Vendor as required.

alibd225
Contributor

Re: Show the column by Calculation.

please see the attached

Re: Show the column by Calculation.

what will be the expected output?

senpradip007
Valued Contributor III

Re: Show the column by Calculation.

PFA. Hope it will help.

Not applicable

Re: Show the column by Calculation.

This is my expected output

Dept      Employee

Dept1      73%

Dept2      82%

Dept3       71%

The percentage value may be wrong, But I need the output like as above.

And one more thing I don't 've rights to open qvw files so pls reply me an expression . That is enough to me

senpradip007
Valued Contributor III

Re: Show the column by Calculation.

PFA

Not applicable

Re: Show the column by Calculation.

Ji am using personal edition only I can't open this qvw file so can you please text me what exactly you did on that qvw...

Community Browser