Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
A to the point answer by Gysbert..