topic Re: How to filter the data in expressions ? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164608#M889810 <HTML><HEAD></HEAD><BODY><P>try like </P><P>if(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">PriceMovement=0,<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">PriceMovement)</SPAN></SPAN></P></BODY></HTML> Wed, 24 Aug 2016 12:28:00 GMT avinashelite 2016-08-24T12:28:00Z How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164603#M889805 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>How to filter the data in expressions ?</P><P></P><P>Below is the chart - Straight table </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quote Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>First Date Quote</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Last Date Quote</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Price Movement</TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>1. Quote Name is the dimension.</P><P>2. First date <SPAN style="font-size: 13.3333px;">Quote </SPAN>is expression - Max(Quote date) - 1, Bid value.</P><P>3. Last date Quote is expression <SPAN style="font-size: 13.3333px;">- Max(Quote date),&nbsp; Bid value.</SPAN></P><P><SPAN style="font-size: 13.3333px;">4. Price Movement is First Date Quote - Last Quote Date.</SPAN></P><P></P><P>So query is in Price Movement i want to filter data as only value with 0.</P><P>How can i achieve the above ?</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164603#M889805 2020-11-25T16:16:04Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164604#M889806 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>with conditional expressions</P><P></P><P>HTH</P><P></P><P>André Gomes</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135409_Untitled.png" /></P></BODY></HTML> Wed, 24 Aug 2016 10:34:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164604#M889806 agomes1971 2016-08-24T10:34:15Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164605#M889807 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P>sum({&lt;[<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Price Movement]={0}</SPAN>&gt;}[<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Price Movement</SPAN>]) </P></BODY></HTML> Wed, 24 Aug 2016 11:02:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164605#M889807 avinashelite 2016-08-24T11:02:15Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164606#M889808 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">MinString also returns null value, I do not want null value in the report.</SPAN></P></BODY></HTML> Wed, 24 Aug 2016 11:16:25 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164606#M889808 2016-08-24T11:16:25Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164607#M889809 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply.</P><P></P><P><IMG alt="PM.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135423_PM.PNG" style="height: auto;" /></P><P></P><P>Giving error.</P></BODY></HTML> Wed, 24 Aug 2016 11:22:01 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164607#M889809 2016-08-24T11:22:01Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164608#M889810 <HTML><HEAD></HEAD><BODY><P>try like </P><P>if(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">PriceMovement=0,<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">PriceMovement)</SPAN></SPAN></P></BODY></HTML> Wed, 24 Aug 2016 12:28:00 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164608#M889810 avinashelite 2016-08-24T12:28:00Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164609#M889811 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 13.3333px;">Do you have a Field name as Price Movement?</SPAN></P><P>In your expression PriceMovement is a Label and showing in blue color. </P></BODY></HTML> Thu, 25 Aug 2016 06:23:00 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164609#M889811 2016-08-25T06:23:00Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164610#M889812 <HTML><HEAD></HEAD><BODY><P>This also shows the null values.</P><P>I do not want null values in the report only with Price Movement as 0 to be shown.</P><P></P><P>Example:</P><P>if PriceMovement = 0 it displays 0 as PriceMovement otherwise it shows '-' in PriceMovement column.</P><P>So i dont want '-' to see.</P><P></P><P>Please help</P></BODY></HTML> Thu, 25 Aug 2016 11:51:01 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164610#M889812 2016-08-25T11:51:01Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164611#M889813 <HTML><HEAD></HEAD><BODY><P>Yes PriceMovement is column label name.</P></BODY></HTML> Thu, 25 Aug 2016 11:51:33 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164611#M889813 2016-08-25T11:51:33Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164612#M889814 <HTML><HEAD></HEAD><BODY><P>Hi Girish,</P><P>Try adding this as a calculated dimension to your chart:</P><P></P><P>=Aggr(if(FirstSortedValue([Bid Value],-[Quote Date]) - FirstSortedValue([Bid Value],-[Quote Date],2)=0,'No','Yes'),[Quote Name])</P><P></P><P>Then (hopefully) selecting 'No' in this calculated dimension will ask QV to select those values in the <SPAN style="font-size: 13.3333px;">[Quote Name] dimension for which the Price Movement is zero.</SPAN></P><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Thu, 25 Aug 2016 12:38:59 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164612#M889814 effinty2112 2016-08-25T12:38:59Z Re: How to filter the data in expressions ? https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164613#M889815 <HTML><HEAD></HEAD><BODY><P>Could you please share the sample data and the app. so that it will helpful&nbsp; for us to debug </P></BODY></HTML> Thu, 25 Aug 2016 13:38:02 GMT https://community.qlik.com/t5/QlikView/How-to-filter-the-data-in-expressions/m-p/1164613#M889815 avinashelite 2016-08-25T13:38:02Z