topic Re: Set analysis - unexpected results in QlikView

Set analysis - unexpected results

Thu, 30 Oct 2014 11:47:37 GMT

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?

Re: Set analysis - unexpected results

Colin-Albert — Thu, 30 Oct 2014 11:50:47 GMT

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.

Re: Set analysis - unexpected results

MK_QSL — Thu, 30 Oct 2014 11:53:45 GMT

Try below

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

Re: Set analysis - unexpected results

Anonymous — Thu, 30 Oct 2014 11:53:53 GMT

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

Re: Set analysis - unexpected results

Thu, 30 Oct 2014 11:57:13 GMT

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

Re: Set analysis - unexpected results

ashfaq_haseeb — Thu, 30 Oct 2014 11:59:01 GMT

Try with this

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

Regards

ASHFAQ