topic Re: How to use set analyst in dimensions? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453291#M434730 <HTML><HEAD></HEAD><BODY><P>Change the second expression to this in <A href="https://community.qlik.com/people/tresesco">tresesco</A>‌'s solution</P><P><STRONG>FirstSortedValue({&lt;Quarter = {"$(='&lt;=' &amp; Max(Quarter))"}&gt;}Tier, -Quarter ,2)</STRONG></P></BODY></HTML> Thu, 11 Jan 2018 12:42:54 GMT sunny_talwar 2018-01-11T12:42:54Z How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453286#M434725 <HTML><HEAD></HEAD><BODY><P>as data in attach file How to use set analyst in dimensions?<BR />I have sheet "Data" and need result as sheet "Result"</P></BODY></HTML> Thu, 11 Jan 2018 07:52:27 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453286#M434725 panwipa2528 2018-01-11T07:52:27Z Re: How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453287#M434726 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you want to do this in frontend or script will also do?</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 11 Jan 2018 08:02:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453287#M434726 kaushiknsolanki 2018-01-11T08:02:06Z Re: How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453288#M434727 <HTML><HEAD></HEAD><BODY><P>Hello Panwipa</P><P>check attached qvw</P><P>I added 3 additional fields to the read data from excel :</P><P>Key : unique value</P><P>Now: today's quarter</P><P>Previous Quarter: the quarter just before today's quarter </P><P>and I used them in set analysis </P><P>hope this helps</P></BODY></HTML> Thu, 11 Jan 2018 08:09:18 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453288#M434727 ali_hijazi 2018-01-11T08:09:18Z Re: How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453289#M434728 <HTML><HEAD></HEAD><BODY><P>One front-end solution could be using <STRONG>firstsortedvalue()</STRONG> like:</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189684_Capture.JPG" style="height: 217px; width: 620px;" /></P></BODY></HTML> Thu, 11 Jan 2018 10:16:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453289#M434728 tresB 2018-01-11T10:16:26Z Re: How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453290#M434729 <HTML><HEAD></HEAD><BODY><P>if I select quarter from time series The result can not display.</P><P>How can I do?</P></BODY></HTML> Thu, 11 Jan 2018 10:29:10 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453290#M434729 panwipa2528 2018-01-11T10:29:10Z Re: How to use set analyst in dimensions? https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453291#M434730 <HTML><HEAD></HEAD><BODY><P>Change the second expression to this in <A href="https://community.qlik.com/people/tresesco">tresesco</A>‌'s solution</P><P><STRONG>FirstSortedValue({&lt;Quarter = {"$(='&lt;=' &amp; Max(Quarter))"}&gt;}Tier, -Quarter ,2)</STRONG></P></BODY></HTML> Thu, 11 Jan 2018 12:42:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-analyst-in-dimensions/m-p/1453291#M434730 sunny_talwar 2018-01-11T12:42:54Z