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.