topic Pivot data and dynamic color it in QlikView

topic Pivot data and dynamic color it in QlikView https://community.qlik.com/t5/QlikView/Pivot-data-and-dynamic-color-it/m-p/401302#M149321 <HTML><HEAD></HEAD><BODY><P>I have two line items like below and I have been able to create one row with tow columns as Current Month and Last Month</P><P> but </P><P>I have been failing in dynamically color them. </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> <BR /></SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 12pt;">Any idea?</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 400px;"><TBODY><TR><TD height="20" style="border: 0px black;" width="159"></TD><TD style="border: 0px black;" width="99"></TD><TD style="border: 0px black;" width="78"></TD><TD style="border: 0px black;" width="64"></TD></TR><TR><TD class="ecxxl66" height="20" style="border: 0.5pt solid windowtext; background-color: #d9d9d9;">Student Name</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">YearMonth</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Subject</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Pass/Fail</TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">201303</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Math</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Fail</TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">201304</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Math</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Pass</TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD colspan="2" height="20" style="border: 0px black;">The report  should look like</TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD class="ecxxl66" height="20" style="border: 0.5pt solid windowtext; background-color: #d9d9d9;">Student Name</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Current Month</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Last Month</TD><TD style="border: 0px black;"></TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;">201304</TD><TD align="right" class="ecxxl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ff5050;">201303</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 25 Apr 2013 19:07:56 GMT 2013-04-25T19:07:56Z Pivot data and dynamic color it https://community.qlik.com/t5/QlikView/Pivot-data-and-dynamic-color-it/m-p/401302#M149321 <HTML><HEAD></HEAD><BODY><P>I have two line items like below and I have been able to create one row with tow columns as Current Month and Last Month</P><P> but </P><P>I have been failing in dynamically color them. </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> <BR /></SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 12pt;">Any idea?</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 400px;"><TBODY><TR><TD height="20" style="border: 0px black;" width="159"></TD><TD style="border: 0px black;" width="99"></TD><TD style="border: 0px black;" width="78"></TD><TD style="border: 0px black;" width="64"></TD></TR><TR><TD class="ecxxl66" height="20" style="border: 0.5pt solid windowtext; background-color: #d9d9d9;">Student Name</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">YearMonth</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Subject</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Pass/Fail</TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">201303</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Math</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Fail</TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">201304</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Math</TD><TD class="ecxxl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;">Pass</TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD colspan="2" height="20" style="border: 0px black;">The report  should look like</TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD height="20" style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD><TD style="border: 0px black;"></TD></TR><TR><TD class="ecxxl66" height="20" style="border: 0.5pt solid windowtext; background-color: #d9d9d9;">Student Name</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Current Month</TD><TD class="ecxxl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #d9d9d9;">Last Month</TD><TD style="border: 0px black;"></TD></TR><TR><TD class="ecxxl65" height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;">John</TD><TD align="right" class="ecxxl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #92d050;">201304</TD><TD align="right" class="ecxxl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: #ff5050;">201303</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 25 Apr 2013 19:07:56 GMT https://community.qlik.com/t5/QlikView/Pivot-data-and-dynamic-color-it/m-p/401302#M149321 2013-04-25T19:07:56Z