topic Re: how to get one image in QlikView https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938813#M323947 <HTML><HEAD></HEAD><BODY><P>sorry but does it matter if its an expression or a calculated dimension?</P><P></P><P>sergey.. yours give me data.. when its in the expression section.. but not when its in the calculated dimension section..</P></BODY></HTML> Thu, 08 Oct 2015 16:27:21 GMT Anonymous 2015-10-08T16:27:21Z how to get one image https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938810#M323944 <HTML><HEAD></HEAD><BODY><P>hi all</P><P></P><P>i have a table where i have styles,styleimages and season.</P><P></P><P>i want just one image grouped for each style based on the highest season.</P><P></P><P>i tried</P><P></P><P>=MAX({$}aggr(distinct(styleimage),styles,season))</P><P></P><P>but its not quite working</P><P></P><P>i thought with the formula above it should output 1 style image based on the make season by style</P><P></P><P>any help would be great</P><P></P><P>thanks</P></BODY></HTML> Thu, 08 Oct 2015 14:07:37 GMT https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938810#M323944 Anonymous 2015-10-08T14:07:37Z Re: how to get one image https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938811#M323945 <HTML><HEAD></HEAD><BODY><P>Is Season is what type of field. Can you please share some data ?</P><P></P><P>as per my understanding, you can try like below:</P><P></P><P><STRONG>Only({&lt;styles={"=Rank(Count(season))=1"}&gt;}styleiamge)</STRONG></P></BODY></HTML> Thu, 08 Oct 2015 15:11:19 GMT https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938811#M323945 2015-10-08T15:11:19Z Re: how to get one image https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938812#M323946 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FirstSortedValue(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">styleimage</SPAN>,-Aggr(<SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; color: #0000ff;">max</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt;">(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">season</SPAN></SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt;">)</SPAN>,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">styles</SPAN>))</STRONG></P></BODY></HTML> Thu, 08 Oct 2015 15:18:58 GMT https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938812#M323946 pokassov 2015-10-08T15:18:58Z Re: how to get one image https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938813#M323947 <HTML><HEAD></HEAD><BODY><P>sorry but does it matter if its an expression or a calculated dimension?</P><P></P><P>sergey.. yours give me data.. when its in the expression section.. but not when its in the calculated dimension section..</P></BODY></HTML> Thu, 08 Oct 2015 16:27:21 GMT https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938813#M323947 Anonymous 2015-10-08T16:27:21Z Re: how to get one image https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938814#M323948 <HTML><HEAD></HEAD><BODY><P>its numeric.</P><P></P><P>sorry but i tried and it didnt work in either calculated dimension or as an expression.</P><P></P><P>thanks</P></BODY></HTML> Thu, 08 Oct 2015 16:28:02 GMT https://community.qlik.com/t5/QlikView/how-to-get-one-image/m-p/938814#M323948 Anonymous 2015-10-08T16:28:02Z