topic Re: How can I manage selection (default selection) in straight table? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904360#M314436 <HTML><HEAD></HEAD><BODY><P>Hi Wei,</P><P></P><P>Could you please upload an example of your table.</P><P></P><P>Regards,</P><P></P><P>Karla</P></BODY></HTML> Mon, 27 Apr 2015 03:03:49 GMT Anonymous 2015-04-27T03:03:49Z How can I manage selection (default selection) in straight table? https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904359#M314435 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P><SPAN style="font-size: 10pt;">I created a straight table, the dimension is calculated, which is something like: =<SPAN style="color: #0000ff;">Pick</SPAN>(<SPAN style="color: #0000ff;">Match</SPAN>(<SPAN style="color: #800000;">Program</SPAN>, 'P1', 'P2', 'P3'), <SPAN style="color: #800000;">[P1 Name]</SPAN>, <SPAN style="color: #800000;">[P2 ID]</SPAN>, <SPAN style="color: #800000;">[P3 Org]</SPAN></SPAN><SPAN style="font-size: 10pt;">) . Everything looks fine. For example, when I make selection Program='P1', the table will show all P1 names together with all related aggregation values. My fact table for this calculated dimension part showed below. </SPAN></P><P></P><TABLE border="1" class="jiveBorder" height="172" style="border: 1px solid rgb(0, 0, 0); width: 386px; height: 111.59px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Program</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>P1 name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>P2 ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>P3 Org</STRONG></TH></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">name1</TD><TD style="padding: 2px;">ID1</TD><TD style="padding: 2px;">O1</TD></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">name2</TD><TD style="padding: 2px;">ID2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">name1</TD><TD style="padding: 2px;">ID3</TD><TD style="padding: 2px;">O1</TD></TR><TR><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">name3</TD><TD style="padding: 2px;">ID3</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">name3</TD><TD style="padding: 2px;">ID2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">name3</TD><TD style="padding: 2px;">ID1</TD><TD style="padding: 2px;">O2</TD></TR></TBODY></TABLE><P> </P><P><SPAN style="font-size: 10pt;">So, in my straight table, when Program='P1', the calculated dimension should show name1 and name 2. Program=P2, show ID2 and ID 3, etc.</SPAN></P><P></P><P><SPAN><SPAN>It is fine when just look at the straight table, but when I click to select name1, I just want to see name1 aggregated information, which should only show me one row. however, I got wrong result, and the current selection section showed, I selected P1 name&nbsp;&nbsp;&nbsp; name1, P2 ID&nbsp; ID1 and P3 Org&nbsp; O1 at the same time. I think it makes sense since I have 3 columns used for this calculated dimension. If I create a list box just show P1 name field and make selection, the straight table will display correctly.</SPAN></SPAN></P><P> </P><P><SPAN><SPAN>Is there anyway I can handle the selection?</SPAN></SPAN></P></BODY></HTML> Fri, 24 Apr 2015 18:13:39 GMT https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904359#M314435 fionna51 2015-04-24T18:13:39Z Re: How can I manage selection (default selection) in straight table? https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904360#M314436 <HTML><HEAD></HEAD><BODY><P>Hi Wei,</P><P></P><P>Could you please upload an example of your table.</P><P></P><P>Regards,</P><P></P><P>Karla</P></BODY></HTML> Mon, 27 Apr 2015 03:03:49 GMT https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904360#M314436 Anonymous 2015-04-27T03:03:49Z Re: How can I manage selection (default selection) in straight table? https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904361#M314437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Aggr and distinct functions may help you. </P></BODY></HTML> Mon, 27 Apr 2015 04:10:44 GMT https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904361#M314437 hariprasadqv 2015-04-27T04:10:44Z Re: How can I manage selection (default selection) in straight table? https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904362#M314438 <HTML><HEAD></HEAD><BODY><P>Thanks. I will find time to create an example.</P></BODY></HTML> Thu, 14 May 2015 20:18:19 GMT https://community.qlik.com/t5/QlikView/How-can-I-manage-selection-default-selection-in-straight-table/m-p/904362#M314438 fionna51 2015-05-14T20:18:19Z