topic Re: Show the column by Calculation. in QlikView https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941882#M528719 <HTML><HEAD></HEAD><BODY><P>This is my expected output</P><P></P><P>Dept&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Employee</P><P>Dept1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 73%</P><P>Dept2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 82%</P><P>Dept3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71%</P><P></P><P></P><P>The percentage value may be wrong, But I need the output like as above.</P><P></P><P>And one more thing I don't 've rights to open qvw files so pls reply me an expression . That is enough to me</P></BODY></HTML> Tue, 18 Aug 2015 06:19:03 GMT 2015-08-18T06:19:03Z Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941875#M528712 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to show the Dept by the below condition.</P><P></P><P>my condition is show Department which have more than 60% of employee compare to Vendor. Here I attached Source file for your reference...</P><P></P><P>And please tell me if it is not possible means....</P><P></P><P></P><P>Thanks in Advance</P></BODY></HTML> Tue, 18 Aug 2015 05:29:58 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941875#M528712 2015-08-18T05:29:58Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941876#M528713 <HTML><HEAD></HEAD><BODY><P>use =if(Vendor/Employee*100&gt;60,Dept) in dimension</P><P>and check suppress when value is null</P><P>and <IMG alt="demp.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96296_demp.png" style="height: 549px; width: 620px;" /></P></BODY></HTML> Tue, 18 Aug 2015 05:38:22 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941876#M528713 alibd225 2015-08-18T05:38:22Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941877#M528714 <HTML><HEAD></HEAD><BODY><P>ji that is not working</P></BODY></HTML> Tue, 18 Aug 2015 05:51:11 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941877#M528714 2015-08-18T05:51:11Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941878#M528715 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 18 Aug 2015 06:03:54 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941878#M528715 2015-08-18T06:03:54Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941879#M528716 <HTML><HEAD></HEAD><BODY><P>please see the attached</P></BODY></HTML> Tue, 18 Aug 2015 06:04:59 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941879#M528716 alibd225 2015-08-18T06:04:59Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941880#M528717 <HTML><HEAD></HEAD><BODY><P>what will be the expected output?</P></BODY></HTML> Tue, 18 Aug 2015 06:09:30 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941880#M528717 Kushal_Chawda 2015-08-18T06:09:30Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941881#M528718 <HTML><HEAD></HEAD><BODY><P>PFA. Hope it will help.</P></BODY></HTML> Tue, 18 Aug 2015 06:09:56 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941881#M528718 senpradip007 2015-08-18T06:09:56Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941882#M528719 <HTML><HEAD></HEAD><BODY><P>This is my expected output</P><P></P><P>Dept&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Employee</P><P>Dept1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 73%</P><P>Dept2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 82%</P><P>Dept3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71%</P><P></P><P></P><P>The percentage value may be wrong, But I need the output like as above.</P><P></P><P>And one more thing I don't 've rights to open qvw files so pls reply me an expression . That is enough to me</P></BODY></HTML> Tue, 18 Aug 2015 06:19:03 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941882#M528719 2015-08-18T06:19:03Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941883#M528720 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 18 Aug 2015 06:29:08 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941883#M528720 senpradip007 2015-08-18T06:29:08Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941884#M528721 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Tue, 18 Aug 2015 06:32:32 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941884#M528721 2015-08-18T06:32:32Z Re: Show the column by Calculation. https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941885#M528722 <HTML><HEAD></HEAD><BODY><P>1.&nbsp; =if(Vendor/Employee*100&gt;60,Dept) in dimension</P><P>2. Check mark when Value is null</P><P>3. write expression =Vendor/Employee</P><P>4, show number tab and set show in percentage</P></BODY></HTML> Tue, 18 Aug 2015 06:38:52 GMT https://community.qlik.com/t5/QlikView/Show-the-column-by-Calculation/m-p/941885#M528722 alibd225 2015-08-18T06:38:52Z