topic best method to show conditional data? in QlikView https://community.qlik.com/t5/QlikView/best-method-to-show-conditional-data/m-p/329443#M1167959 <HTML><HEAD></HEAD><BODY><P>Again, new to QlikView, just wondered what is best method to show in a worksheet data between a certain range, for example, only show data where a particular value is between x and y.&nbsp; If this was to be deployed to user base, would not want them to have to do this via edit script ideally....&nbsp; Is there another way apart from highlighting relevant values in the list box?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 31 Jul 2012 15:14:52 GMT 2012-07-31T15:14:52Z best method to show conditional data? https://community.qlik.com/t5/QlikView/best-method-to-show-conditional-data/m-p/329443#M1167959 <HTML><HEAD></HEAD><BODY><P>Again, new to QlikView, just wondered what is best method to show in a worksheet data between a certain range, for example, only show data where a particular value is between x and y.&nbsp; If this was to be deployed to user base, would not want them to have to do this via edit script ideally....&nbsp; Is there another way apart from highlighting relevant values in the list box?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 31 Jul 2012 15:14:52 GMT https://community.qlik.com/t5/QlikView/best-method-to-show-conditional-data/m-p/329443#M1167959 2012-07-31T15:14:52Z Re: best method to show conditional data? https://community.qlik.com/t5/QlikView/best-method-to-show-conditional-data/m-p/329444#M1167960 <HTML><HEAD></HEAD><BODY><P>You could try calculated dimensions: </P><P></P><P>Like: </P><P></P><P>Aggr(If(Sum(Sales)&gt;1000,Customer,'Others'),Customer) </P><P></P><P>This should only give you a list of customer who have sales over 1000 and rest will be clubed under "Others"</P></BODY></HTML> Tue, 31 Jul 2012 15:18:23 GMT https://community.qlik.com/t5/QlikView/best-method-to-show-conditional-data/m-p/329444#M1167960 2012-07-31T15:18:23Z