calculate total value only associate with two dimensions

[#1]

Hi there,

I am working on a dashbaord utilizing retail data. The data field includes item code, store code, invoice date, department and item sales quantity. I am going to calculate the total sales for all the itmes sold on specific day in the specific store.

I have tried expression=sum(item_qty) but it does not work since the value will change when specific department is selected. Is there a way to do the calculation of total value which will not change regardless item code and department are selected.

Thank you!

Gloria

[Colin-Albert · Accepted solution]

sum( {<item_code=, department= >} item_qty)

will exclude selections on item_code or department from the quantity, selections on other fields will still affect the figure.

[Colin-Albert]

There is more info on set analysis and a wizard to help create the expressions here.

http://community.qlik.com/message/170190#170190

[#4]

Thank you so much for your help!! It works!