topic Re: Price range in dimension in QlikView https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032938#M348558 <HTML><HEAD></HEAD><BODY><P>Do you have a sample you can share?</P></BODY></HTML> Mon, 21 Mar 2016 09:50:27 GMT sunny_talwar 2016-03-21T09:50:27Z Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032935#M348555 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I'm trying to do a price analysis on actual vs agreed prices. </P><P></P><P>So I would like the dimension to be a range of prices and the expression to count the qty of products sold at that price. </P><P>I used the class function to calculate the range for the dimension: class(salesvalue/salesqty, vRange). </P><P>I'd like to have 2 expressions as bars: </P><P>count(salesvalue/salesqty) </P><P>count(agreedvalue/agreedqty)</P><P></P><P>I can't get the 2nd expression to appear on the chart. I'm assuming it's because of my dimension since I only used salesvalue/salesqty to determine the range for the dimension. </P><P></P><P>Any help would be much appreciated. Thanks! </P></BODY></HTML> Mon, 21 Mar 2016 08:21:18 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032935#M348555 ninnartx 2016-03-21T08:21:18Z Re: Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032936#M348556 <HTML><HEAD></HEAD><BODY><P>all the fields in the same table? if they are in different tables, is there any link between the tables?</P></BODY></HTML> Mon, 21 Mar 2016 09:46:33 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032936#M348556 PradeepReddy 2016-03-21T09:46:33Z Re: Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032937#M348557 <HTML><HEAD></HEAD><BODY><P>share a sample app, then it would be easy to suggest rather than guessing...</P></BODY></HTML> Mon, 21 Mar 2016 09:47:19 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032937#M348557 PradeepReddy 2016-03-21T09:47:19Z Re: Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032938#M348558 <HTML><HEAD></HEAD><BODY><P>Do you have a sample you can share?</P></BODY></HTML> Mon, 21 Mar 2016 09:50:27 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032938#M348558 sunny_talwar 2016-03-21T09:50:27Z Re: Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032939#M348559 <HTML><HEAD></HEAD><BODY><P>I somehow managed to get the second expression to show but it's not showing the correct data. </P></BODY></HTML> Mon, 21 Mar 2016 10:16:52 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032939#M348559 ninnartx 2016-03-21T10:16:52Z Re: Price range in dimension https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032940#M348560 <HTML><HEAD></HEAD><BODY><P>Please check the attachment above ^ </P><P></P><P>Thanks! </P></BODY></HTML> Mon, 21 Mar 2016 10:17:57 GMT https://community.qlik.com/t5/QlikView/Price-range-in-dimension/m-p/1032940#M348560 ninnartx 2016-03-21T10:17:57Z