topic Re: Multiple Conditions and Multiple variables in set analysis in QlikView

Multiple Conditions and Multiple variables in set analysis

Fri, 20 Jan 2017 15:20:49 GMT

I have a pivot chart where I am trying to calculate a field called available capacity.. But this based on a variable and another field.

I want to say:

if vshowearnedhours=1

then

if pooled=' ' sum (availablecapacity)

or if pooled='x'

sum availablecapacity/count (distinct [work center])

I tried doing set analysis and here is what I have but it is not working at all..

=if($(vShowEarnedHours),
Sum({$<Poolk={''}>}AvailableCapacity) + sum({$<Poolk={'X'}>}AvailableCapacity/Count(DISTINCT [Work Center])))

Re: Multiple Conditions and Multiple variables in set analysis

sunny_talwar — Fri, 20 Jan 2017 16:33:21 GMT

May be try this?

=If($(vShowEarnedHours) = 1,

If(Len(Trim(Poolk)) = 0, Sum(AvailableCapacity),

If(Poolk = 'X', sum(AvailableCapacity)/Count(DISTINCT [Work Center]))))

Re: Multiple Conditions and Multiple variables in set analysis

Fri, 20 Jan 2017 17:47:19 GMT

thanks, but does not work.. no results..

Re: Multiple Conditions and Multiple variables in set analysis

sunny_talwar — Sat, 21 Jan 2017 15:25:23 GMT

Would you be able to share a sample or some sample data to show what exactly are you trying to achieve? May be knowing the input and output might help me better understand the issue and give you a solution.

Best,

Sunny

Re: Multiple Conditions and Multiple variables in set analysis

shraddhawalekar — Thu, 18 Apr 2019 06:10:04 GMT

Try Something like this.

=Sum({$<ShowEarnedHours={1},Poolk={''}>}AvailableCapacity)
+
Sum({$<ShowEarnedHours={1},Poolk={'X'}>}AvailableCapacity/Count(DISTINCT [Work Center]))