Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Set- Analysis for Today (Current Value) based on location

I know qliksense automatically creates associations. I have different filter panes across the sheets available. However, for this particular set analysis I would like to calculate Today's Inventory Value or Current Inventory Value.. But I would like the user to be able to filter this by warehouse.  It should only be affected if the warehouse filter is selected. Otherwise if certain months are selected or year, etc the set analysis should not be affected. Please let me know how this can be achieved.

Currently I have the following:

MAX(If(ind = 'inventory', LinkTable_Join))

This gives the maximum inventory Date Value. I need to multiple all the Sales purchase * Owned Quantity to this but to be able to be filtered by warehouse. What would the set analysis look like. I am pretty new to qlik, so help would be immensely appreciated.