Hi,
I am a beginner user in Qlik. Recently the developer made a table where I have a number of items and net sales sold in every country.
Now I would like to calculate the average item price in the same table by using an expression:
Sum({<[Flag.Current]={1}>}[#NetSales]/[#SalesQuantity])
I basically took NetSales expression and tried to divide it in Sales Quantity, this is what I would do in a calculator, but it, of course, does not work in QS.
Could you please help me?
Thank you in advance.