topic Create a table having built in condition. in QlikView

Create a table having built in condition.

Wed, 01 Oct 2014 22:30:58 GMT

I have a table having the columns Name, Department , Salary and sex.

I want to build and show a table for all male employees. The table should have name, department and salary and should display only values where sex='m' by default.

Any help would be appreciated. Thanks

Re: Create a table having built in condition.

Gysbert_Wassenaar — Thu, 02 Oct 2014 13:12:57 GMT

Create a straight table with name and department as dimensions and as expression sum({<sex={'m'}>}salary). Make sure to use the correct case sensitive field names.

Re: Create a table having built in condition.

Thu, 02 Oct 2014 14:33:24 GMT

Thank you the reply Gysbert. I figured that out. I am however looking for a way to show it without any expression which kinda rules the straight table out.

Re: Create a table having built in condition.

bgerchikov — Thu, 02 Oct 2014 15:38:35 GMT

Hi Ravi,

You need this condition somewhere in the chart or another option is to set a trigger on opening to assign "m" to field sex.

In chart you can set this condition in expression set analysis or in dimension:

if(sex='m', Dimension_Field,null())

Hope it will help

Re: Create a table having built in condition.

Colin-Albert — Thu, 02 Oct 2014 15:43:48 GMT

If you want to do it without an expression, then add a listbox for the field sex alongside your chart.

Click on m and your chart will show the data for males.

Re: Create a table having built in condition.

Gysbert_Wassenaar — Fri, 03 Oct 2014 07:39:01 GMT

Ok, try alternates states then. Create a new alternate state. Create your table box. Assign the table box to the new alternate state. Select the value 'm'. Right click the column and choose Lock.