Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I get the feeling I am doing something stupid, but I'm going to ask the question anyway.
I have a pretty simple expression for my bar chart, in which the dimension is Calendar Week.
COUNT(DISTINCT {$<Firm={'ACME*'}>}UserName)
For some reason when I make any selection in the 'Firm' list box, the values do not change at all. Selections in the Calendar Date list boxes do work though.
Why is this?
Your set expression is explicitly setting a value for Firm.
This will override any selections you make elsewhere in the app.
Hence the value does not change when you make selections on Firm.
Try below
COUNT(DISTINCT {$<Firm *={'ACME*'}>}UserName)
As you have set {$<Firm={'ACME*'}>}
So it will always giveyou the results based on Firm='ACME' only based on other fields selection except Firm.....
And defining *= the intersection of currently selected Firm and the Firm “ACME”.
If require, you can use it
Regards
Nitin
Your set exp is working correct way because in modifier <Firm={'ACME*'}> you have used Firm field so any selection in Firm list box will be disregarded.
any other list box selection will work because they are not explicitly used in set modifier.
hope it helps
Try with this
COUNT(DISTINCT {$<Firm*={'ACME*'}>}UserName)
Regards
ASHFAQ