This content has been marked as final. Show 2 replies
I'm trying to create a select in field action by using the concat function, but I'm having an issue with the set analysis.
I need to limit my product selection to just products which are sold in >50% of stores, so I'm trying the set analysis:
I don't think anything can be done in script to per-aggregate, as it's dependent on the current store selection, as well as the timeframe. Qlikview doesn't seem to like having an aggregation function in the set analysis however.
Is there another way to do this?