topic Re: Straight Table Chart - Forced Field in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955874#M328493 <HTML><HEAD></HEAD><BODY><P>Add Set Analysis in the Straight Table expression to force it to only evaluate for West Ham, maybe something like :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; = only ( {&lt;Team={'West Ham'}&gt;} Form)</P></BODY></HTML> Fri, 06 Nov 2015 17:52:44 GMT Anonymous 2015-11-06T17:52:44Z Straight Table Chart - Forced Field https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955872#M328491 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The attached screenshot shows a page I have mocked up. In the bottom right corner is a Straight Table chart called Form Guide. You can see that I currently have Team = "West Ham" selected. Can you please advise how I can force the straight table to always display data when the Team field in this table = West Ham. I have tried a few conditional formats but they make the data disappear unless I manually select the team. I would like the table forced to display all data for a certain team. Is this possible? </P><P></P><P><IMG alt="form guide.png" class="jive-image image-1" src="/legacyfs/online/104280_form guide.png" style="width: 620px; height: 335px;" /></P></BODY></HTML> Fri, 06 Nov 2015 17:10:20 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955872#M328491 2015-11-06T17:10:20Z Re: Straight Table Chart - Forced Field https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955873#M328492 <HTML><HEAD></HEAD><BODY><P>Share the mocked up dashboard.</P></BODY></HTML> Fri, 06 Nov 2015 17:48:33 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955873#M328492 prabhu0505 2015-11-06T17:48:33Z Re: Straight Table Chart - Forced Field https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955874#M328493 <HTML><HEAD></HEAD><BODY><P>Add Set Analysis in the Straight Table expression to force it to only evaluate for West Ham, maybe something like :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; = only ( {&lt;Team={'West Ham'}&gt;} Form)</P></BODY></HTML> Fri, 06 Nov 2015 17:52:44 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955874#M328493 Anonymous 2015-11-06T17:52:44Z Re: Straight Table Chart - Forced Field https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955875#M328494 <HTML><HEAD></HEAD><BODY><P>Many thanks Bill, that's perfect ! </P></BODY></HTML> Fri, 06 Nov 2015 17:55:23 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Chart-Forced-Field/m-p/955875#M328494 2015-11-06T17:55:23Z