Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Try below

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

View solution in original post

5 Replies
Highlighted

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.

Highlighted
MVP
MVP

Try below

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

View solution in original post

Highlighted
Specialist II
Specialist II

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

Highlighted
Not applicable

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

Highlighted

Try with this

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


Regards

ASHFAQ