topic Re: suggest in QlikView https://community.qlik.com/t5/QlikView/suggest/m-p/680529#M674082 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a look at class() function.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 14 Aug 2014 09:58:36 GMT ashfaq_haseeb 2014-08-14T09:58:36Z suggest https://community.qlik.com/t5/QlikView/suggest/m-p/680528#M674081 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>Please suggest how shall i proceed with below mention scenario</P><P>where row labels is the difference of two dates from same table...</P><P>how to make buckets in backend </P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 265px;"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">Row Labels</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P><SPAN style="color: black;">Count of Reservation Status</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">&lt;0</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">84</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">0-30</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">19704</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">30-60</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">19334</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">60-90</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">13078</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">90-120</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">11236</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">120-150</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">10777</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">150-180</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">9029</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">&gt;180</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">255</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">Grand Total</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="159"><P align="right" style="text-align: right;"><SPAN style="color: black;">83497</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>thanks in Advance</P></BODY></HTML> Thu, 14 Aug 2014 09:56:08 GMT https://community.qlik.com/t5/QlikView/suggest/m-p/680528#M674081 2014-08-14T09:56:08Z Re: suggest https://community.qlik.com/t5/QlikView/suggest/m-p/680529#M674082 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a look at class() function.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 14 Aug 2014 09:58:36 GMT https://community.qlik.com/t5/QlikView/suggest/m-p/680529#M674082 ashfaq_haseeb 2014-08-14T09:58:36Z Re: suggest https://community.qlik.com/t5/QlikView/suggest/m-p/680530#M674083 <HTML><HEAD></HEAD><BODY><P>Class() function is a good way..even you can use nested if conditions but it will take a lots of memory and calculation time .</P></BODY></HTML> Thu, 14 Aug 2014 10:01:39 GMT https://community.qlik.com/t5/QlikView/suggest/m-p/680530#M674083 sujeetsingh 2014-08-14T10:01:39Z Re: suggest https://community.qlik.com/t5/QlikView/suggest/m-p/680531#M674084 <HTML><HEAD></HEAD><BODY><P>Use Class() function. You can also use IntervalMatch in the script.</P></BODY></HTML> Thu, 14 Aug 2014 12:26:33 GMT https://community.qlik.com/t5/QlikView/suggest/m-p/680531#M674084 2014-08-14T12:26:33Z