Hi; I'm a newbie trying out the free versions of Qlik View and
Sense. I'd like to see if there's a way to do a particular type of Set Analysis.
Assuming my current selection includes products of the type PT and a particular customer and channel. How would I compare total Sales for that selection against total sales for the same customer, same channel, but NON PT products?
The first one will give you the Sales for all selections that you have made whereas scond one will not consider the selection on Product Type but it will give the sales for slected customer and channel.
I tried Borja's recommendation and that seems to work for doing a straight sum. I've created a Master item with this formula and another one for Volume (shipped units). If I want to get an average, can I add another Master item measure for a calculation like Volume/Sales? I tried it and the result is just a null value.
Thanks for the response. I did already get it to work using the source formulas for the individual calculations. I was just wondering if it was possible to use the calculation names instead of the source formulas? If so, I haven't figured out how to get it to actually work.