topic Re: Valueloop in QlikView

Valueloop

Wed, 31 Aug 2016 12:52:03 GMT

Hello All,

Could you please help me with the expression below:

Sum(Valueloop(0,(Count(DISTINCT {<FirstAgent={'<>0'}>}(Agent))/Count(DISTINCT(Date))),2))

The value loop does not seem to function with "(Count(DISTINCT {<FirstAgent={'<>0'}>}(Agent)"

Any idea?

Many Thanks,

Hasvine

Re: Valueloop

sunny_talwar — Wed, 31 Aug 2016 12:57:48 GMT

Is the number suppose to change for each dimension? If that's true, then it might not work. If it is a single number for all the dimensions, you can try this:

Sum(Valueloop(0, $(=(Count(DISTINCT {<FirstAgent={'<>0'}>}Agent)/Count(DISTINCT Date))), 2))

Re: Valueloop

antoniotiman — Wed, 31 Aug 2016 14:17:12 GMT

FirstAgent-={0}