topic Re: IS THE EXPR CORRECT? in QlikView

IS THE EXPR CORRECT?

Thu, 30 Oct 2014 10:42:45 GMT

if(dir=abc,sum(usedspace)/sum({<=only({<dir={'abc'}>},totalspace)),0)

Thu, 30 Oct 2014 10:47:09 GMT

Expression is not correct

its_anandrjs — Thu, 30 Oct 2014 10:48:49 GMT

No i assume dir holds the abc values then put single quotes for that

if(dir = 'abc', sum( usedspace ) / sum( {<=only( {<dir={'abc'} >} ,totalspace)) , 0 )

ashfaq_haseeb — Thu, 30 Oct 2014 10:54:29 GMT

Try like this

if(dir='abc',sum(usedspace)/sum({<=only({<dir={'abc'}>},totalspace)),0)

Regards

ASHFAQ

alexandros17 — Thu, 30 Oct 2014 10:56:26 GMT

try this:

if(dir='abc',sum(usedspace)/sum({$ <only({<dir={'abc'}>},totalspace)),0)

Thu, 30 Oct 2014 11:20:34 GMT

Try this

I think there should not b comma (,) before totalspace

if(dir=abc,sum(usedspace)/sum({<=only({<dir={'abc'}>} totalspace)),0)

Thu, 30 Oct 2014 11:49:19 GMT

Not working

my actual requirements if dir ='abc' then output should be sum(usedspace)/850

here 850 is total space if i go with 850 i am getting correct result that is static but i want as a dynamic

instead of 850 i want write condition .

if i go with simple sum(totalspace) then it is talking entire space ,i dont want like that

if dir =abc then need to calculate related to abc total space i.e i written like above expression

ashfaq_haseeb — Thu, 30 Oct 2014 11:56:08 GMT

Hi,

It doesn't make sense.

Can you come-up with some sample data.

Then what does sum(usedspace) returns?

Regards

ASHFAQ

rubenmarin — Thu, 30 Oct 2014 12:02:33 GMT

Hi, maybe:

if(dir='abc',sum(usedspace)/only({<dir={'abc'}>} totalspace),0)