topic Re: Price Range in QlikView https://community.qlik.com/t5/QlikView/Price-Range/m-p/399521#M1162727 <HTML><HEAD></HEAD><BODY><P>Nice! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> A slight variation on the theme in the attached qvw. I've used a pivot table and pivot'ed Range to columns. That way only one expression count(AC_Net) is necessary. If you have a lot of ranges it will save some time setting it up. Also set analysis expressions aren't necessary this way.</P></BODY></HTML> Wed, 10 Oct 2012 14:54:05 GMT Gysbert_Wassenaar 2012-10-10T14:54:05Z Price Range https://community.qlik.com/t5/QlikView/Price-Range/m-p/399519#M1162725 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Would anyone be able to help with the below problem I'm having. I'm trying to set up a table that contains a list of products and the price ranges we have sold products for. I have enclosed a spreadsheet to better illustrate what I am trying to achieve.</P><P></P><P>I'm new to qlikview so all feeback would be welcome.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 10 Oct 2012 13:48:36 GMT https://community.qlik.com/t5/QlikView/Price-Range/m-p/399519#M1162725 2012-10-10T13:48:36Z Re: Price Range https://community.qlik.com/t5/QlikView/Price-Range/m-p/399520#M1162726 <HTML><HEAD></HEAD><BODY><P>See attached example. </P></BODY></HTML> Wed, 10 Oct 2012 14:45:19 GMT https://community.qlik.com/t5/QlikView/Price-Range/m-p/399520#M1162726 2012-10-10T14:45:19Z Re: Price Range https://community.qlik.com/t5/QlikView/Price-Range/m-p/399521#M1162727 <HTML><HEAD></HEAD><BODY><P>Nice! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> A slight variation on the theme in the attached qvw. I've used a pivot table and pivot'ed Range to columns. That way only one expression count(AC_Net) is necessary. If you have a lot of ranges it will save some time setting it up. Also set analysis expressions aren't necessary this way.</P></BODY></HTML> Wed, 10 Oct 2012 14:54:05 GMT https://community.qlik.com/t5/QlikView/Price-Range/m-p/399521#M1162727 Gysbert_Wassenaar 2012-10-10T14:54:05Z Re: Price Range https://community.qlik.com/t5/QlikView/Price-Range/m-p/399522#M1162728 <HTML><HEAD></HEAD><BODY><P>Thanks, gwassenaar! I didn't even think about that, but that would save time. </P></BODY></HTML> Wed, 10 Oct 2012 14:55:28 GMT https://community.qlik.com/t5/QlikView/Price-Range/m-p/399522#M1162728 2012-10-10T14:55:28Z Re: Price Range https://community.qlik.com/t5/QlikView/Price-Range/m-p/399523#M1162729 <HTML><HEAD></HEAD><BODY><P>Thanks both for your feedback, very helpful</P></BODY></HTML> Wed, 10 Oct 2012 14:59:21 GMT https://community.qlik.com/t5/QlikView/Price-Range/m-p/399523#M1162729 2012-10-10T14:59:21Z