topic Re: Pivot or Straight Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612847#M226157 <HTML><HEAD></HEAD><BODY><P>yes.. the best can be get by adding a calculated dimension as below..</P><P></P><P>=Model &amp; ' - '&amp;[Sub-Model]</P><P></P><P>now you can remove Model and Sub-Model fields also..</P></BODY></HTML> Mon, 24 Mar 2014 08:18:37 GMT MK_QSL 2014-03-24T08:18:37Z Pivot or Straight Table https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612844#M226154 <HTML><HEAD></HEAD><BODY><P><STRONG>Hello Community,</STRONG></P><P></P><P><STRONG>I want to use Tree List box like structure in my Straight or Pivot table.</STRONG></P><P></P><P><STRONG>Is this possible or not. Please help..</STRONG></P><P></P><P><STRONG>Please find attached QVW and image for the help.</STRONG></P><P></P><P><STRONG>- Thanks and Regards,</STRONG></P><P><STRONG>Vishal Waghole</STRONG></P></BODY></HTML> Mon, 24 Mar 2014 08:01:10 GMT https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612844#M226154 VishalWaghole 2014-03-24T08:01:10Z Re: Pivot or Straight Table https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612845#M226155 <HTML><HEAD></HEAD><BODY><P>The best possible way is already shown by you...</P></BODY></HTML> Mon, 24 Mar 2014 08:03:22 GMT https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612845#M226155 MK_QSL 2014-03-24T08:03:22Z Re: Pivot or Straight Table https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612846#M226156 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Thanks for your valueable reply,</P><P></P><P>But can i mearge Model and Sub-Model Column in Pivot table like Tree List Box Structure.</P><P></P><P>- Regards,</P><P>Vishal</P></BODY></HTML> Mon, 24 Mar 2014 08:07:31 GMT https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612846#M226156 VishalWaghole 2014-03-24T08:07:31Z Re: Pivot or Straight Table https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612847#M226157 <HTML><HEAD></HEAD><BODY><P>yes.. the best can be get by adding a calculated dimension as below..</P><P></P><P>=Model &amp; ' - '&amp;[Sub-Model]</P><P></P><P>now you can remove Model and Sub-Model fields also..</P></BODY></HTML> Mon, 24 Mar 2014 08:18:37 GMT https://community.qlik.com/t5/QlikView/Pivot-or-Straight-Table/m-p/612847#M226157 MK_QSL 2014-03-24T08:18:37Z