topic Re: choose column field in QlikView

topic Re: choose column field in QlikView https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066727#M1223482 <P>i have column(producttype ,utmccn,utmcmd and all ) i want <STRONG>product  type</STRONG> field <STRONG>cruises   (</STRONG>in cruises i want more 5 sub field with other column).</P> <TABLE width="265"> <TBODY> <TR> <TD width="93"><STRONG>Product Type</STRONG></TD> <TD width="86"><STRONG>UTMCCN</STRONG></TD> <TD width="86"><STRONG>UTMCMD</STRONG></TD> </TR> <TR> <TD>cruises</TD> <TD>(direct)</TD> <TD>(not set)</TD> </TR> <TR> <TD>holiday fit</TD> <TD>(not set)</TD> <TD>email</TD> </TR> <TR> <TD>holiday git</TD> <TD>(organic)</TD> <TD>EmailMA</TD> </TR> <TR> <TD>forex</TD> <TD>(referral)</TD> <TD>organic</TD> </TR> <TR> <TD>int holiday fit</TD> <TD>air</TD> <TD>referral</TD> </TR> <TR> <TD>int holiday git</TD> <TD>nonair</TD> <TD>paid</TD> </TR> </TBODY> </TABLE> <P> </P> <P>I want to create Table Like this </P> <TABLE> <TBODY> <TR> <TD width="119.156px" height="25px"> <DIV><STRONG>Product Type</STRONG></DIV> </TD> <TD width="84.4219px" height="25px">23-Apr-23</TD> <TD width="84.4219px" height="25px">24-Apr-23</TD> <TD width="84.4219px" height="25px">25-Apr-23</TD> <TD width="84.4219px" height="25px">26-Apr-23</TD> <TD width="116.297px" height="25px">MTD Achieved</TD> <TD width="175.859px" height="25px">FTM Trend</TD> </TR> <TR> <TD width="119.156px" height="47px"><STRONG>DOM Holiday FIT</STRONG></TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Direct</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Email + MA</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Organic</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Paid</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Referral</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="116.297px" height="25px"> </TD> <TD width="175.859px" height="25px"> </TD> </TR> <TR> <TD width="119.156px" height="47px"><STRONG>DOM Holiday GIT</STRONG></TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Direct</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Email + MA</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Organic</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Paid</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Referral</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="25px"> </TD> </TR> </TBODY> </TABLE> Tue, 02 May 2023 12:53:03 GMT inam 2023-05-02T12:53:03Z choose column field https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066506#M1223474 <P>Hello Community </P> <P>i have a 3 column i want to choose column sub field</P> <P>for example </P> <P>input :-</P> <TABLE width="265"> <TBODY> <TR> <TD width="92.5px"><STRONG>Product Type</STRONG></TD> <TD width="85.7344px"><STRONG>UTMCCN</STRONG></TD> <TD width="85.7656px"><STRONG>UTMCMD</STRONG></TD> </TR> <TR> <TD width="92.5px">cruises</TD> <TD width="85.7344px">(direct)</TD> <TD width="85.7656px">(not set)</TD> </TR> <TR> <TD width="92.5px">holiday fit</TD> <TD width="85.7344px">(not set)</TD> <TD width="85.7656px">email</TD> </TR> <TR> <TD width="92.5px">holiday git</TD> <TD width="85.7344px">(organic)</TD> <TD width="85.7656px">EmailMA</TD> </TR> <TR> <TD width="92.5px">forex</TD> <TD width="85.7344px">(referral)</TD> <TD width="85.7656px">organic</TD> </TR> <TR> <TD width="92.5px">int holiday fit</TD> <TD width="85.7344px">air</TD> <TD width="85.7656px">referral</TD> </TR> <TR> <TD width="92.5px">int holiday git</TD> <TD width="85.7344px">nonair</TD> <TD width="85.7656px">BPN</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Expected Output:-</P> <TABLE width="265"> <TBODY> <TR> <TD width="93"><STRONG>Product type</STRONG></TD> <TD width="86"><STRONG>Product type</STRONG></TD> <TD width="86"><STRONG>Product type</STRONG></TD> </TR> <TR> <TD><STRONG>cruises</STRONG></TD> <TD><STRONG>holiday fit</STRONG></TD> <TD><STRONG>holiday git</STRONG></TD> </TR> <TR> <TD>Direct </TD> <TD>Direct</TD> <TD>Direct</TD> </TR> <TR> <TD>emailMA</TD> <TD>emailMA</TD> <TD>emailMA</TD> </TR> <TR> <TD>organic</TD> <TD>organic</TD> <TD>organic</TD> </TR> <TR> <TD>referral</TD> <TD>referral</TD> <TD>referral</TD> </TR> </TBODY> </TABLE> <P> </P> <P>(same for forex, int holiday fit, int holiday git)</P> <P> </P> Tue, 02 May 2023 05:43:49 GMT https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066506#M1223474 inam 2023-05-02T05:43:49Z Re: choose column field https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066558#M1223477 <P>You can use the Label name  option to change the column name as per my understanding,</P> <P>or else if you want to select only sub characters from the field with the function</P> <P>Subfield(fieldname, starting postion,  no of characters)</P> Tue, 02 May 2023 07:28:26 GMT https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066558#M1223477 Prem0212 2023-05-02T07:28:26Z Re: choose column field https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066633#M1223479 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/222774">@inam</a>  it seems complicated. Could you elaborate more?  I cannot see any pattern here</P> Tue, 02 May 2023 10:31:38 GMT https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066633#M1223479 Kushal_Chawda 2023-05-02T10:31:38Z Re: choose column field https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066727#M1223482 <P>i have column(producttype ,utmccn,utmcmd and all ) i want <STRONG>product  type</STRONG> field <STRONG>cruises   (</STRONG>in cruises i want more 5 sub field with other column).</P> <TABLE width="265"> <TBODY> <TR> <TD width="93"><STRONG>Product Type</STRONG></TD> <TD width="86"><STRONG>UTMCCN</STRONG></TD> <TD width="86"><STRONG>UTMCMD</STRONG></TD> </TR> <TR> <TD>cruises</TD> <TD>(direct)</TD> <TD>(not set)</TD> </TR> <TR> <TD>holiday fit</TD> <TD>(not set)</TD> <TD>email</TD> </TR> <TR> <TD>holiday git</TD> <TD>(organic)</TD> <TD>EmailMA</TD> </TR> <TR> <TD>forex</TD> <TD>(referral)</TD> <TD>organic</TD> </TR> <TR> <TD>int holiday fit</TD> <TD>air</TD> <TD>referral</TD> </TR> <TR> <TD>int holiday git</TD> <TD>nonair</TD> <TD>paid</TD> </TR> </TBODY> </TABLE> <P> </P> <P>I want to create Table Like this </P> <TABLE> <TBODY> <TR> <TD width="119.156px" height="25px"> <DIV><STRONG>Product Type</STRONG></DIV> </TD> <TD width="84.4219px" height="25px">23-Apr-23</TD> <TD width="84.4219px" height="25px">24-Apr-23</TD> <TD width="84.4219px" height="25px">25-Apr-23</TD> <TD width="84.4219px" height="25px">26-Apr-23</TD> <TD width="116.297px" height="25px">MTD Achieved</TD> <TD width="175.859px" height="25px">FTM Trend</TD> </TR> <TR> <TD width="119.156px" height="47px"><STRONG>DOM Holiday FIT</STRONG></TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Direct</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Email + MA</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Organic</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Paid</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Referral</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="84.4219px" height="25px"> </TD> <TD width="116.297px" height="25px"> </TD> <TD width="175.859px" height="25px"> </TD> </TR> <TR> <TD width="119.156px" height="47px"><STRONG>DOM Holiday GIT</STRONG></TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="84.4219px" height="47px">Total</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Direct</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Email + MA</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Organic</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Paid</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="47px">Referral</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="84.4219px" height="47px">Lead Count</TD> <TD width="116.297px" height="47px">Total lead Count</TD> <TD width="175.859px" height="47px">Trend basis MTD Achieved</TD> </TR> <TR> <TD width="119.156px" height="25px"> </TD> </TR> </TBODY> </TABLE> Tue, 02 May 2023 12:53:03 GMT https://community.qlik.com/t5/QlikView/choose-column-field/m-p/2066727#M1223482 inam 2023-05-02T12:53:03Z