Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - unexpected results

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?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Try below

COUNT(DISTINCT {$<Firm *={'ACME*'}>}UserName)

View solution in original post

5 Replies
Colin-Albert

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.

MK_QSL
MVP
MVP

Try below

COUNT(DISTINCT {$<Firm *={'ACME*'}>}UserName)

Anonymous
Not applicable
Author

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

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Try with this

COUNT(DISTINCT {$<Firm*={'ACME*'}>}UserName)


Regards

ASHFAQ