topic Re: Use devide operator between set analysis in QlikView

Use devide operator between set analysis

Wed, 06 Nov 2013 13:50:32 GMT

Hi.

I'm trying to use "/" between to set analysis calculations but it doesent work, only get 0. But if i use "+","-" or "*" it works fine. It looks like this:

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600 / sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600

Any suggestions

Re: Use devide operator between set analysis

swuehl — Wed, 06 Nov 2013 13:57:34 GMT

What two values do you get for the two single sum() expressions?

Are you displaying the result with an appropriate amount of decimal places?

Re: Use devide operator between set analysis

bbi_mba_76 — Wed, 06 Nov 2013 14:03:36 GMT

Hi,

maybe there are missing brackets:

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600 /

(sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600 )

and if so you could avoid the /3600

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s) /

(sum({$<Length-={'UNKNOWN'}>} Duration_s) )

Re: Use devide operator between set analysis

kaushalview — Wed, 06 Nov 2013 14:09:27 GMT

Hi,

Use proper Backet Like ().

(sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600)

(sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600)

Regards

Kaushal Mehta

Re: Use devide operator between set analysis

Wed, 06 Nov 2013 14:14:32 GMT

Yes, I think rather that the problem is about how to displaying the numbers.

The values for one month is 3615/232= 15,58189655172414

Re: Use devide operator between set analysis

swuehl — Wed, 06 Nov 2013 14:26:39 GMT

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)

is larger than

sum({$<Length-={'UNKNOWN'}>} Duration_s)

(even there is an additional filter applied)?

Or are you actually calculating 232 / 3615 = 0.064

and displaying only integer / rounded values?