topic Re: crosstable with indicators in line in QlikView https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900216#M530696 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">The data comes from a database not from a file, i have a dimension named Time, Product, Saler and the fact table <SPAN style="font-size: 13.3333330154419px;">Sales.</SPAN></SPAN></P></BODY></HTML> Thu, 25 Jun 2015 12:25:01 GMT 2015-06-25T12:25:01Z crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900211#M530687 <HTML><HEAD></HEAD><BODY><P>hello </P><P>i want to have a table with indicator in line like this :</P><P></P><P>Indicator \ Year&nbsp;&nbsp; 2015&nbsp; 2014</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp; 52</P><P>VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp; 55</P><P>QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp; 10</P><P></P><P><SPAN lang="en">Can you tell me how to do it pls.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Thks in advance<BR /></SPAN></P></BODY></HTML> Thu, 25 Jun 2015 11:41:43 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900211#M530687 2015-06-25T11:41:43Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900212#M530689 <HTML><HEAD></HEAD><BODY><P>You want it like this?</P><P></P><P><STRONG>Indicator&nbsp;&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp;&nbsp; Value</STRONG></P><P><STRONG>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 20</STRONG></P><P><STRONG>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 52</STRONG></P><P><STRONG>VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 20</STRONG></P><P><STRONG>VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 55</STRONG></P><P><STRONG>QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P><P><STRONG>QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P></BODY></HTML> Thu, 25 Jun 2015 12:01:15 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900212#M530689 sunny_talwar 2015-06-25T12:01:15Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900213#M530690 <HTML><HEAD></HEAD><BODY><P>If yes, then try the following script:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * Inline [</STRONG></P><P><STRONG>Indicator, 2015, 2014</STRONG></P><P><STRONG>CA, 20, 52</STRONG></P><P><STRONG>VOL, 20, 55</STRONG></P><P><STRONG>QTY, 10, 10</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>NewTable:</STRONG></P><P><STRONG>CrossTable (Year, Data, 1)</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>Resident Table;</STRONG></P><P></P><P><STRONG>DROP Table Table;</STRONG></P><P><STRONG><BR /></STRONG></P><P>Output:</P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90824_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Thu, 25 Jun 2015 12:04:56 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900213#M530690 sunny_talwar 2015-06-25T12:04:56Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900214#M530692 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I want it like this </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Indicator \ Year&nbsp;&nbsp; 2015&nbsp; 2014</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 52</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 55</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">but if i have this one i'll do what i want</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Indicator&nbsp;&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp;&nbsp; Value</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 20</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 52</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 20</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 55</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp; 10</STRONG></P></BODY></HTML> Thu, 25 Jun 2015 12:07:37 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900214#M530692 2015-06-25T12:07:37Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900215#M530694 <HTML><HEAD></HEAD><BODY><P>I am unsure of how your data is right now and how you want it to look like. Can you share an example of what your data looks like?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 25 Jun 2015 12:10:14 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900215#M530694 sunny_talwar 2015-06-25T12:10:14Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900216#M530696 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">The data comes from a database not from a file, i have a dimension named Time, Product, Saler and the fact table <SPAN style="font-size: 13.3333330154419px;">Sales.</SPAN></SPAN></P></BODY></HTML> Thu, 25 Jun 2015 12:25:01 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900216#M530696 2015-06-25T12:25:01Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900217#M530697 <HTML><HEAD></HEAD><BODY><P>Your data looks like this?</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Indicator \ Year&nbsp; 2015&nbsp; 2014</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 52</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 55</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 10</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">or this?</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Indicator&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Value</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp; 20</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp; 52</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp; 20</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">VOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp; 55</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015&nbsp;&nbsp;&nbsp; 10</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">QTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp; 10</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">This is what is confusing me right now.</P></BODY></HTML> Thu, 25 Jun 2015 12:29:16 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900217#M530697 sunny_talwar 2015-06-25T12:29:16Z Re: crosstable with indicators in line https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900218#M530699 <HTML><HEAD></HEAD><BODY><P>Here the table that i want to pivot<IMG alt="cap.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90816_cap.png" style="height: 216px; width: 620px;" /></P></BODY></HTML> Thu, 25 Jun 2015 12:30:50 GMT https://community.qlik.com/t5/QlikView/crosstable-with-indicators-in-line/m-p/900218#M530699 2015-06-25T12:30:50Z