topic Re: Need help?? in QlikView https://community.qlik.com/t5/QlikView/Need-help/m-p/711121#M1060206 <HTML><HEAD></HEAD><BODY><P>please provide sample application</P></BODY></HTML> Sun, 28 Sep 2014 15:44:21 GMT MarcoWedel 2014-09-28T15:44:21Z Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711118#M1060203 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Community,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have one requirement....</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">suppose i have a Days.. like..</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">These are my input fields...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Ex:&nbsp;&nbsp;&nbsp; <STRONG style="font-style: inherit; font-family: inherit;">Start_day&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End_Date</STRONG></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="font-style: inherit; font-family: inherit;">Generate Report</STRONG></P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If i am click generate report button i want to generate report based on input dates....&nbsp; <STRONG style="font-style: inherit; font-family: inherit;">Customer and SalesPerson</STRONG> standard fields...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Like this</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Custmer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SalesPerson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10-30 days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31-45 Days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45-60 Days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61 to MaxDays</STRONG></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAAA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5890&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3300000</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ABVB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ABC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 230&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000000</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">is this possible............??</P></BODY></HTML> Sun, 28 Sep 2014 13:06:36 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711118#M1060203 Nagaraju_KCS 2014-09-28T13:06:36Z Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711119#M1060204 <HTML><HEAD></HEAD><BODY><P>You need to look at class() function.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 28 Sep 2014 13:08:24 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711119#M1060204 ashfaq_haseeb 2014-09-28T13:08:24Z Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711120#M1060205 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P></P><P>I made that bucket..</P><P>but i need input range</P><P>Suppose: </P><P>Start_Range&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End_Range</P><P>10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P>50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P></P><P>When i am click <STRONG>Generate Report</STRONG> button i want to generate report</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-style: inherit; font-family: inherit;"><STRONG>Custmer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SalesPerson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10-30 days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30-45 Days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50-80 Days&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 81 to MaxDays</STRONG></SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">XXX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAAA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5890&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3300000</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ABVB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ABC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 230&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 790&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000000</P><P></P><P>Hope you understand.................</P></BODY></HTML> Sun, 28 Sep 2014 13:31:12 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711120#M1060205 Nagaraju_KCS 2014-09-28T13:31:12Z Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711121#M1060206 <HTML><HEAD></HEAD><BODY><P>please provide sample application</P></BODY></HTML> Sun, 28 Sep 2014 15:44:21 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711121#M1060206 MarcoWedel 2014-09-28T15:44:21Z Re: Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711122#M1060207 <HTML><HEAD></HEAD><BODY><P>Hi Macro,</P><P></P><P>Please See this link <A href="https://community.qlik.com/thread/133942">Need Help??</A></P><P></P><P>PFA,</P></BODY></HTML> Sun, 28 Sep 2014 16:02:49 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711122#M1060207 Nagaraju_KCS 2014-09-28T16:02:49Z Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711123#M1060208 <HTML><HEAD></HEAD><BODY><P>Example.</P><P></P><P>Persona:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Customer, PersonalSales, Days</P><P>&nbsp;&nbsp;&nbsp; Cust1, PersSale1, 10</P><P>&nbsp;&nbsp;&nbsp; Cust1, PersSale1, 40</P><P>&nbsp;&nbsp;&nbsp; Cust1, PersSale2, 100</P><P>&nbsp;&nbsp;&nbsp; Cust1, PersSale2, 11</P><P>&nbsp;&nbsp;&nbsp; Cust2, PersSale3, 58</P><P>&nbsp;&nbsp;&nbsp; Cust2, PersSale1, 22</P><P>&nbsp;&nbsp;&nbsp; Cust2, PersSale2, 16</P><P>&nbsp;&nbsp;&nbsp; Cust2, PersSale2, 30</P><P>];</P><P></P><P>RangeDays:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Star_Days, End_Days, Desc_Days</P><P>&nbsp;&nbsp;&nbsp; 10, 30, 10-30 Days</P><P>&nbsp;&nbsp;&nbsp; 31, 45, 31-45 Days</P><P>&nbsp;&nbsp;&nbsp; 45, 60, 45-60 Days</P><P>&nbsp;&nbsp;&nbsp; 61, 100000, 61 to MaxDays</P><P>];</P><P></P><P>left join (RangeDays)</P><P>IntervalMatch (Days) LOAD Star_Days, End_Days Resident RangeDays;</P><P></P><P><IMG alt="RangeDays.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67826_RangeDays.JPG.jpg" /></P><P>atte.</P><P>Luis Valencia</P></BODY></HTML> Sun, 28 Sep 2014 16:15:17 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711123#M1060208 2014-09-28T16:15:17Z Re: Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711124#M1060209 <HTML><HEAD></HEAD><BODY><P>Hi Luis,</P><P></P><P>But here, based on user input values.....</P></BODY></HTML> Sun, 28 Sep 2014 16:21:55 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711124#M1060209 Nagaraju_KCS 2014-09-28T16:21:55Z Re: Re: Re: Need help?? https://community.qlik.com/t5/QlikView/Need-help/m-p/711125#M1060210 <HTML><HEAD></HEAD><BODY><P>es lo que buscas?.</P></BODY></HTML> Mon, 29 Sep 2014 00:28:54 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/711125#M1060210 2014-09-29T00:28:54Z