topic Can I limit the data in a Table Box using a field value? in QlikView https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55126#M511196 <HTML><HEAD></HEAD><BODY><P>I have a Table Box that I want to limit the data for only data from 2018.&nbsp; Is that possible to do?</P></BODY></HTML> Wed, 04 Apr 2018 14:10:14 GMT cliff_clayman 2018-04-04T14:10:14Z Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55126#M511196 <HTML><HEAD></HEAD><BODY><P>I have a Table Box that I want to limit the data for only data from 2018.&nbsp; Is that possible to do?</P></BODY></HTML> Wed, 04 Apr 2018 14:10:14 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55126#M511196 cliff_clayman 2018-04-04T14:10:14Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55127#M511197 <HTML><HEAD></HEAD><BODY><P>I think the only option is to select 2018, as a workaround it can be in another altern state, but selections will be done in this state.</P><P></P><P>Another option is using a simple table showing the fields as dimensions with an expression that filters the data with set analysis, or use the expression that filters the data to show some existing field as expression instead of showing as dimension.</P></BODY></HTML> Wed, 04 Apr 2018 14:19:49 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55127#M511197 rubenmarin 2018-04-04T14:19:49Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55128#M511198 <HTML><HEAD></HEAD><BODY><P>Why can't this be done using a Table Box?&nbsp; Seems like this should be something that should be easily done.</P></BODY></HTML> Wed, 04 Apr 2018 14:23:19 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55128#M511198 cliff_clayman 2018-04-04T14:23:19Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55129#M511199 <HTML><HEAD></HEAD><BODY><P>Table box is only used to show some static data values. You cannot do much with this object. May be use Straight table. Can you explain a little more on whats your expected output. Can you share some sample data?</P></BODY></HTML> Wed, 04 Apr 2018 14:26:47 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55129#M511199 vishsaggi 2018-04-04T14:26:47Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55130#M511200 <HTML><HEAD></HEAD><BODY><P>One option is to create a new field in the script like this</P><P><STRONG>If(Year = 2018, 1) as FlagYear</STRONG></P><P></P><P>Now add FlagYear as one of the fields in your table box and then go to the presentation tab and check 'Omit Rows Where Field is NULL' for the FlagYear dimension.</P><P></P><P>Make sure to do this for FlagYear to make it work...</P></BODY></HTML> Wed, 04 Apr 2018 14:27:33 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55130#M511200 sunny_talwar 2018-04-04T14:27:33Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55131#M511201 <HTML><HEAD></HEAD><BODY><P>TableBox doesn't allows for calculated expression, another workaround can be adding a field that copies the year value but with only values in 2018 (others as null) and in presentation tab check the option to omit rows with null values.</P></BODY></HTML> Wed, 04 Apr 2018 14:28:28 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55131#M511201 rubenmarin 2018-04-04T14:28:28Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55132#M511202 <HTML><HEAD></HEAD><BODY><P>Can I somehow keep from showing the FlagYear column in the table box?</P></BODY></HTML> Wed, 04 Apr 2018 14:33:37 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55132#M511202 cliff_clayman 2018-04-04T14:33:37Z Re: Can I limit the data in a Table Box using a field value? https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55133#M511203 <HTML><HEAD></HEAD><BODY><P>‌Then do as Ruben suggested... create a new year field</P><P></P><P>If(Year = 2018, Year) as Year_New</P><P></P><P>and then instead of adding Year, add Year_New as your field and select the omit option on the presentation tab. Oh and ya please remember to label Year_New as Year because I am sure you would not like to see Year_New as a column label&nbsp; </P></BODY></HTML> Wed, 04 Apr 2018 14:38:42 GMT https://community.qlik.com/t5/QlikView/Can-I-limit-the-data-in-a-Table-Box-using-a-field-value/m-p/55133#M511203 sunny_talwar 2018-04-04T14:38:42Z