topic Set analysis problem in QlikView

Set analysis problem

Thu, 17 Nov 2011 12:44:57 GMT

I've data like this..

Cavnum	Length	inspCount
1	0	1
1	52.901067	1
1	64.78034	1
2	0	1
2	48.396422	1
2	346.09862	1
3	0	1
3	48.407275	1

- I've two variables(i.e vLB and vUB) in my sheet which i've taken in inputbox. So that user can enter the values here. Let takes vLB = 0 and vUB=46.

- Now i've taken Cavnum as dimension in straight table and 3 expressions as

1. #All -> =sum(inspcount)

2. Small -> =(Sum({$<MeasureLength={"<=$(vLB)"}>} inspcount))

3.Medium -> =(Sum({$<MeasureLength={">$(vLB)<=$(vUB)"}>} inspcount))

4. Large -> =(Sum({$<MeasureLength={">$(vUB)"}>}inspcount))

- I'm not able to get exact values what i want. B'coz i've taken Cavnum, Measure Length in listbox and i'll select 1 as cavnum and 0 from MeasureLength listbox then it shows exact value in the straight table.

Is there any thing wrong in my set analysis..

Set analysis problem

swuehl — Thu, 17 Nov 2011 12:54:46 GMT

Hi,

I think your expressions should work, but please recheck the exact spelling of your field names (case sensitiv).

I think it should be inspCount in your set expression instead of inspcount and Length instead of MeasureLength.

Also check your number format, that the decimal separator is set to '.'

Hope this helps,

Stefan

Re: Set analysis problem

Thu, 17 Nov 2011 13:07:10 GMT

Swuehl,

Sorry the field name is MeasureLength only..

Can you see please the attached image it shows different data in striaght table. When comparing to the selection i made.

Re: Set analysis problem

Wed, 10 Oct 2012 13:50:59 GMT

Try that:

MeasureLength={'$(=num(52.901067))'}

=sum({<MeasureLength={'$(=num(52.901067))'}>}inspcount)

Hope it helps.

Marcos