10 Replies Latest reply: Dec 24, 2012 5:23 AM by sujeet singh RSS

    Problem with Set Analysis

    Jerry Lau

      Hi everyone, I am a newbie to QlikView and I am now studying the use of set analysis

       

      I want to use an expression to select the number of distinct customer who purchases certain product from lines of sales order data.

       

      Please kindly describe what is the difference between

      Count({$<Product={'$(TargetProduct)'}>} DISTINCT [Customer])

      and

      Count({$<Product={$(TargetProduct)}>} DISTINCT [Customer])

      where TargetProduct is a variable name and can be changed by button click actions.

       

      I suppose the second one should be used but it shows nothing while the first statement works.

       

      Thanks!