2 Replies Latest reply: Jul 17, 2014 9:27 AM by Spencer Harris RSS

    Can a function be used as the basis for set analysis?

    Spencer Harris

      Hi all,

       

      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:

       

      {(<count(DISTINCT store_counter_cur)={">.5*$(vTotalStores)">)}

       

      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?

       

      Thanks, Spence