Price Range

[#1]

Hi all,

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.

I'm new to qlikview so all feeback would be welcome.

Thanks

[#2]

See attached example.

[Gysbert_Wassenaar]

Nice! 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.

[#4]

Thanks, gwassenaar! I didn't even think about that, but that would save time.

[#5]

Thanks both for your feedback, very helpful