topic Re: Data retrieval based on priority... Help Me..Check the screen shot attached. in QlikView https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337895#M1170033 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>I created an additional ID field for the records using recno() in the LOAD script, the created a table chart with a calculated dimension:</P><P></P><P><EM>=aggr(nodistinct if(rangesum(istext(area),istext(customer))=min(total&lt;location&gt; rangesum(IsText(area),istext(customer))), ID), location, ID)</EM></P><P></P><P>You can hide all columns that you don't want to see.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Fri, 06 Jul 2012 16:07:40 GMT swuehl 2012-07-06T16:07:40Z Data retrieval based on priority... Help Me..Check the screen shot attached. https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337892#M1170030 <HTML><HEAD></HEAD><BODY><P>can any one help me , how to retrieve the data by priority vise in the expression.</P><P></P><P>Example: i hav the data</P><P></P><P>location,Area , customername, Capacity...four columns...</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>location<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>area<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle">customer</TH><TH align="center" style="background-color: #6690bc;" valign="middle">capacity</TH></TR><TR><TD style="border: 1px solid #000000;">chennai</TD><TD style="border: 1px solid #000000;"><BR /></TD><TD style="border: 1px solid #000000;"><BR /></TD><TD style="border: 1px solid #000000;">500</TD></TR><TR><TD style="border: 1px solid #000000;">chennai</TD><TD style="border: 1px solid #000000;">sipcot</TD><TD style="border: 1px solid #000000;"><BR /></TD><TD style="border: 1px solid #000000;">800</TD></TR><TR><TD style="border: 1px solid #000000;">chennai</TD><TD style="border: 1px solid #000000;">sipcot</TD><TD style="border: 1px solid #000000;">Avula</TD><TD style="border: 1px solid #000000;">400</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>if my selection is chennai,sipcot,avula then the result set is 500,800 and 400.check the screen shot for refernce.</P><P> <STRONG>Attachments:</STRONG> </P><UL><LI> <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/235247-40854/Posting.JPG"><IMG alt="Attachment" border="0" class="jiveImage" src="https://community.qlik.com/servlet/JiveServlet/attachImage?attachImage=true&amp;contentType=image%2Fjpeg&amp;attachment=40854" style="margin: 3px 1px 0 0;" /></A> <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/235247-40854/Posting.JPG">Posting.JPG</A> (88.2 K) </LI></UL></BODY></HTML> Fri, 06 Jul 2012 11:33:01 GMT https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337892#M1170030 2012-07-06T11:33:01Z Re: Data retrieval based on priority... Help Me..Check the screen shot attached. https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337893#M1170031 <HTML><HEAD></HEAD><BODY><P>Well, if you have selected chennai in field location, sipcot in field area and Avula in field customer, you should have limited the results to capacity 400 already.</P><P></P><P>I assume you want to retrieve the value for this line even without any selection in area and customer?</P></BODY></HTML> Fri, 06 Jul 2012 11:40:53 GMT https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337893#M1170031 swuehl 2012-07-06T11:40:53Z Re: Data retrieval based on priority... Help Me..Check the screen shot attached. https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337894#M1170032 <HTML><HEAD></HEAD><BODY><P>Exactly...i need that row alone...</P></BODY></HTML> Fri, 06 Jul 2012 11:45:13 GMT https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337894#M1170032 2012-07-06T11:45:13Z Re: Data retrieval based on priority... Help Me..Check the screen shot attached. https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337895#M1170033 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>I created an additional ID field for the records using recno() in the LOAD script, the created a table chart with a calculated dimension:</P><P></P><P><EM>=aggr(nodistinct if(rangesum(istext(area),istext(customer))=min(total&lt;location&gt; rangesum(IsText(area),istext(customer))), ID), location, ID)</EM></P><P></P><P>You can hide all columns that you don't want to see.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Fri, 06 Jul 2012 16:07:40 GMT https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337895#M1170033 swuehl 2012-07-06T16:07:40Z Re: Data retrieval based on priority... Help Me..Check the screen shot attached. https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337896#M1170034 <HTML><HEAD></HEAD><BODY><P>Thank u,,</P><P></P><P>verymuch helpful....</P><P></P><P>Rgds,</P><P>Avula.gk</P></BODY></HTML> Mon, 09 Jul 2012 07:16:47 GMT https://community.qlik.com/t5/QlikView/Data-retrieval-based-on-priority-Help-Me-Check-the-screen-shot/m-p/337896#M1170034 2012-07-09T07:16:47Z