topic Re: Expression Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397431#M424065 <HTML><HEAD></HEAD><BODY><P>This one for example.</P><P>In the first text box i would like to see the first price, for example for the product A. So the correct value should be 1,1</P><P></P><P>Andrea</P></BODY></HTML> Wed, 15 Nov 2017 14:31:03 GMT andrea90casa 2017-11-15T14:31:03Z Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397424#M424058 <HTML><HEAD></HEAD><BODY><P>Hi at all,</P><P></P><P>I have a dataset with one field called data and another one called unit price</P><P></P><P>I would like to create a formula that shows me the first available unit price for a specific product, i have created a variable called MinData with this formula =Min(data)</P><P></P><P>And then i wanted to try this one</P><P></P><P>Avg({&lt;data = $(=MinData)&gt;}Unit_Price)</P><P></P><P>But it doesn't work, anyone can help me with this..</P><P></P><P>Best regards</P><P></P><P>Andrea</P></BODY></HTML> Wed, 15 Nov 2017 13:57:56 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397424#M424058 andrea90casa 2017-11-15T13:57:56Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397425#M424059 <HTML><HEAD></HEAD><BODY><P>May be flower bracket missed as syntax of set expression</P><P></P><P>Avg({&lt;data = <STRONG>{</STRONG>$(=MinData)<STRONG>}</STRONG>&gt;}Unit_Price)</P></BODY></HTML> Wed, 15 Nov 2017 14:00:51 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397425#M424059 Anil_Babu_Samineni 2017-11-15T14:00:51Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397426#M424060 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>I tried with curly brakets in that position but it hasn't worked too </P></BODY></HTML> Wed, 15 Nov 2017 14:03:23 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397426#M424060 andrea90casa 2017-11-15T14:03:23Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397427#M424061 <HTML><HEAD></HEAD><BODY><P>Try below expression</P><P></P><P>Avg({&lt;data = <STRONG>{"=</STRONG>$(=MinData)"<STRONG>}</STRONG>&gt;}Unit_Price)</P><P>or</P><P>Avg({&lt;data = <STRONG>{"=</STRONG>$(MinData)"<STRONG>}</STRONG>&gt;}Unit_Price)</P></BODY></HTML> Wed, 15 Nov 2017 14:09:35 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397427#M424061 krishnacbe 2017-11-15T14:09:35Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397428#M424062 <HTML><HEAD></HEAD><BODY><P>Try this</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><STRONG>Avg({&lt;data = {'$(MinData)}&gt;}Unit_Price)'</STRONG></P></BODY></HTML> Wed, 15 Nov 2017 14:19:50 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397428#M424062 Anil_Babu_Samineni 2017-11-15T14:19:50Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397429#M424063 <HTML><HEAD></HEAD><BODY><P>with this solutions it calcs the average considering all the unite price and it doesn't give to me the only first one</P></BODY></HTML> Wed, 15 Nov 2017 14:22:15 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397429#M424063 andrea90casa 2017-11-15T14:22:15Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397430#M424064 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data to debug.</P></BODY></HTML> Wed, 15 Nov 2017 14:25:43 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397430#M424064 krishnacbe 2017-11-15T14:25:43Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397431#M424065 <HTML><HEAD></HEAD><BODY><P>This one for example.</P><P>In the first text box i would like to see the first price, for example for the product A. So the correct value should be 1,1</P><P></P><P>Andrea</P></BODY></HTML> Wed, 15 Nov 2017 14:31:03 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397431#M424065 andrea90casa 2017-11-15T14:31:03Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397432#M424066 <HTML><HEAD></HEAD><BODY><P>Check below expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">=aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Unit_Price</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Product</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Wed, 15 Nov 2017 14:41:11 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397432#M424066 krishnacbe 2017-11-15T14:41:11Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397433#M424067 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183385_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>With that expression the result is 1.188 so the mean of all that value, so it is not give to me the min data unit price (01/01/2017 = 1,1)</P></BODY></HTML> Wed, 15 Nov 2017 14:44:48 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397433#M424067 andrea90casa 2017-11-15T14:44:48Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397434#M424068 <HTML><HEAD></HEAD><BODY><P>MinData variable settings I have added expression as <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Min</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">data</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">data</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(MinData)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Unit_Price</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Hope it works</SPAN></P></BODY></HTML> Wed, 15 Nov 2017 14:57:29 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397434#M424068 krishnacbe 2017-11-15T14:57:29Z Re: Expression Set Analysis https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397435#M424069 <HTML><HEAD></HEAD><BODY><P>Thank you very much. It's works</P></BODY></HTML> Wed, 15 Nov 2017 14:59:11 GMT https://community.qlik.com/t5/QlikView/Expression-Set-Analysis/m-p/1397435#M424069 andrea90casa 2017-11-15T14:59:11Z