Hi all. I'm currently working on a table that summarizes all the hazardous items my company has, where they're located, their price, and the inventory price. I want to set up a KPI next to the table that will reflect the sum of all the values for a selected group. For example, if I choose Alabama as the state, I would like the KPI to sum all the values I have for inventory price for Alabama. If I choose Washington, I'd like it to reflect Washington. Etc. I'm not sure how to approach doing this as I'm new to Qlik and was hoping for some help. Thanks!
Add the measure Sum(Inventory) to the KPI. By default this will respect all selections made (i.e., selecting Alabama will only sum Inventory values for Alabama.
