topic Re: two headers in QlikView https://community.qlik.com/t5/QlikView/two-headers/m-p/1238303#M393613 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Model</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sub model</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Quantity</TH></TR><TR><TD rowspan="8" style="padding: 2px;">Apr 09</TD><TD style="padding: 2px;">mini</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Std</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">High Grade</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">Piano</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">Other</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">9</TD></TR><TR><TD rowspan="3" style="padding: 2px;">Indian</TD><TD style="padding: 2px;">CTK 860 IN</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">CTK 6300 IN</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">CTK 7300 IN</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P>i want to get the modelwise quantity for that musical instruments</P></BODY></HTML> Thu, 19 Jan 2017 06:38:48 GMT KumaRan 2017-01-19T06:38:48Z two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238294#M393604 <HTML><HEAD></HEAD><BODY><P>Hi all. Hi all. Here i have excel with two header. i need to do data modelling in this. can anybody help in this?Here i have excel with two header. i need to do data modelling in this. can anybody help in this?</P></BODY></HTML> Thu, 12 Jan 2017 11:46:13 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238294#M393604 KumaRan 2017-01-12T11:46:13Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238295#M393605 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I recommended you load 2 times your data with each header OR build a copy and <SPAN style="font-size: 13.3333px;">clean your data in some sheet to set the information by header maybe.</SPAN></P><P></P><P>Regards</P></BODY></HTML> Thu, 12 Jan 2017 11:52:07 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238295#M393605 enriquem 2017-01-12T11:52:07Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238296#M393606 <HTML><HEAD></HEAD><BODY><P>Kindly Can you eloborate it with my sample data with script?</P></BODY></HTML> Thu, 12 Jan 2017 11:55:56 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238296#M393606 KumaRan 2017-01-12T11:55:56Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238297#M393607 <HTML><HEAD></HEAD><BODY><P>Here you have</P><P></P><P>Regards</P></BODY></HTML> Thu, 12 Jan 2017 12:05:24 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238297#M393607 enriquem 2017-01-12T12:05:24Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238298#M393608 <HTML><HEAD></HEAD><BODY><P>Hi mora,</P><P>What you meant to say?</P></BODY></HTML> Thu, 12 Jan 2017 12:08:23 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238298#M393608 KumaRan 2017-01-12T12:08:23Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238299#M393609 <HTML><HEAD></HEAD><BODY><P>You couldn't see the example?</P></BODY></HTML> Fri, 13 Jan 2017 10:27:57 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238299#M393609 enriquem 2017-01-13T10:27:57Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238300#M393610 <HTML><HEAD></HEAD><BODY><P>Ya i couldn't see any example</P></BODY></HTML> Mon, 16 Jan 2017 06:16:07 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238300#M393610 KumaRan 2017-01-16T06:16:07Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238301#M393611 <HTML><HEAD></HEAD><BODY><P>i can see now.thank you</P></BODY></HTML> Mon, 16 Jan 2017 06:19:14 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238301#M393611 KumaRan 2017-01-16T06:19:14Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238302#M393612 <HTML><HEAD></HEAD><BODY><P>Actually there are more than two headers in your sample data. What kind of data modeling are you looking for? What kind of analysis and visualizations do you want to do?</P></BODY></HTML> Mon, 16 Jan 2017 11:25:31 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238302#M393612 petter 2017-01-16T11:25:31Z Re: two headers https://community.qlik.com/t5/QlikView/two-headers/m-p/1238303#M393613 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Model</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sub model</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Quantity</TH></TR><TR><TD rowspan="8" style="padding: 2px;">Apr 09</TD><TD style="padding: 2px;">mini</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Std</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">High Grade</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">Piano</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">Other</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">9</TD></TR><TR><TD rowspan="3" style="padding: 2px;">Indian</TD><TD style="padding: 2px;">CTK 860 IN</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">CTK 6300 IN</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">CTK 7300 IN</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P>i want to get the modelwise quantity for that musical instruments</P></BODY></HTML> Thu, 19 Jan 2017 06:38:48 GMT https://community.qlik.com/t5/QlikView/two-headers/m-p/1238303#M393613 KumaRan 2017-01-19T06:38:48Z