topic How to show selected and excluded in same table? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-selected-and-excluded-in-same-table/m-p/203711#M60950 <HTML><HEAD></HEAD><BODY><P>It sounds like you just need [Team] as the first dimension and [Customer] as the second dimension but I'm assuming I'm missing something.</P><P></P><P>I think the syntax on this statement is off: Sum ({[Team]} if [Team] = 'B', Sales)</P><P>As far as I know the {[Team]} part doesn't mean anything.</P><P></P><P>If you are trying to get the order of the columns to changed based on your selections... that I'm not sure how to do.</P></BODY></HTML> Thu, 07 Apr 2011 16:37:37 GMT 2011-04-07T16:37:37Z How to show selected and excluded in same table? https://community.qlik.com/t5/QlikView/How-to-show-selected-and-excluded-in-same-table/m-p/203710#M60949 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>Thanks in advance.</P><P>I have a sales report and I would like to have a straight table to show the selected team on left column and all the excluded columns on right by customer.</P><P>Customer: X, Y, Z</P><P>Team: A, B, C, D</P><P>when selected A,</P><P>A | B | C | D</P><P>X 1| 2 | 3 | 4</P><P>Y 2| 4 | 6 | 8</P><P>when selected B,</P><P></P><P>B | A | C | D</P><P>X 2 | 1 | 3 | 4</P><P>Y 4 | 2 | 6 | 8</P><BR /><BR /> <P>I try put and If else case to dynamic to switch the 3 columns on right.</P><P>However, when I try to use the following to get the sum, I can't get the sum correctly.</P><P>Sum ({[Team]} if [Team] = 'B', Sales)</P><P>Anyone can help?</P><P></P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 15:30:46 GMT https://community.qlik.com/t5/QlikView/How-to-show-selected-and-excluded-in-same-table/m-p/203710#M60949 2011-04-07T15:30:46Z How to show selected and excluded in same table? https://community.qlik.com/t5/QlikView/How-to-show-selected-and-excluded-in-same-table/m-p/203711#M60950 <HTML><HEAD></HEAD><BODY><P>It sounds like you just need [Team] as the first dimension and [Customer] as the second dimension but I'm assuming I'm missing something.</P><P></P><P>I think the syntax on this statement is off: Sum ({[Team]} if [Team] = 'B', Sales)</P><P>As far as I know the {[Team]} part doesn't mean anything.</P><P></P><P>If you are trying to get the order of the columns to changed based on your selections... that I'm not sure how to do.</P></BODY></HTML> Thu, 07 Apr 2011 16:37:37 GMT https://community.qlik.com/t5/QlikView/How-to-show-selected-and-excluded-in-same-table/m-p/203711#M60950 2011-04-07T16:37:37Z