https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785118#M1209955 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132405">@tungogers_mbps</a>&nbsp; can you elaborate ?</P><P>can you share a sample data and the expected output in table or file format?</P> Tue, 23 Feb 2021 10:00:38 GMT Taoufiq_Zarra 2021-02-23T10:00:38Z https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785114#M1209954 <P>Hi,</P><P>How do I create a text object with these:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tungogers_mbps_1-1614073462645.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49659i16C6C024C15D9441/image-size/medium?v=v2&amp;px=400" role="button" title="tungogers_mbps_1-1614073462645.png" alt="tungogers_mbps_1-1614073462645.png" /></span></P><P>&nbsp;</P><P>&nbsp;The text object should look like this " For Week [Week], [Team Name] has the lowest volume of [Score]"</P><P>The week is Max(Week).</P><P>I'm new to Qlikview</P><P>Thanks!</P><P>&nbsp;</P> Tue, 23 Feb 2021 09:47:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785114#M1209954 tungogers_mbps 2021-02-23T09:47:14Z https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785118#M1209955 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132405">@tungogers_mbps</a>&nbsp; can you elaborate ?</P><P>can you share a sample data and the expected output in table or file format?</P> Tue, 23 Feb 2021 10:00:38 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785118#M1209955 Taoufiq_Zarra 2021-02-23T10:00:38Z https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785126#M1209956 <P>Hi Taoufiq,</P><P>&nbsp;</P><P>Due to privacy concerns, I can't share the data. Though I provided the screenshot earlier.</P><P>&nbsp;</P><P>the expected out is&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tungogers_mbps_0-1614074726804.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49665iE116AD978BDE64C0/image-size/medium?v=v2&amp;px=400" role="button" title="tungogers_mbps_0-1614074726804.png" alt="tungogers_mbps_0-1614074726804.png" /></span></P><P>&nbsp;</P> Tue, 23 Feb 2021 10:05:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785126#M1209956 tungogers_mbps 2021-02-23T10:05:45Z https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785130#M1209957 <P>from the shared sample what is the expected value of :</P><P>[Week]</P><P>[Team Name]</P><P>[Score]</P><P>&nbsp;</P> Tue, 23 Feb 2021 10:08:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785130#M1209957 Taoufiq_Zarra 2021-02-23T10:08:26Z https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785133#M1209958 <P>The expected values are</P><P>[Week]: Max Week</P><P>[Team Name] Team with the lowest sum of volume</P><P>[Score] the lowest sum of volume</P> Tue, 23 Feb 2021 10:11:31 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-lowest-value-in-a-text-object/m-p/1785133#M1209958 tungogers_mbps 2021-02-23T10:11:31Z