topic Re: if condition? how it works? in QlikView

if condition? how it works?

Anonymous — Tue, 14 Oct 2014 14:14:54 GMT

if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)

Re: if condition? how it works?

sivarajs — Tue, 14 Oct 2014 14:21:39 GMT

Column(n) represent expression column

n=1 means first expression-> column(1) etc...

Re: if condition? how it works?

Anonymous — Tue, 14 Oct 2014 14:24:23 GMT

little clear pls

Re: if condition? how it works?

sivarajs — Tue, 14 Oct 2014 14:30:17 GMT

If you have 4 expression in your chart, if you want to use first expression in second expression you dont want write whole expression again . You can use column(1) in second expression

This will gives values of first expression in second.

Re: if condition? how it works?

Anonymous — Tue, 14 Oct 2014 14:34:07 GMT

that i understood what about 1/coloumn(2) i want about 1/ here?

Re: if condition? how it works?

sivarajs — Tue, 14 Oct 2014 14:45:31 GMT

(1/column(2)/column(3) * 100 ) >0 - dividing 2 and 3 expression, result value divided again by 1 . if this value greater than 0 then it will give result (1/column(1)/column(2)

Re: if condition? how it works?

Tue, 14 Oct 2014 15:03:41 GMT

Hi,

if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)

here we get the values for column(2) and column(3) suppose here we got the values 100,200 for column(2) and column(3)

here lokks like this if(1/100/200*100)>0,1/100/200*100,0)

Re: if condition? how it works?

Anonymous — Tue, 14 Oct 2014 15:14:10 GMT

expression ouput what?
if(1/100/200*100)>0,1/100/200*100,0)

Re: if condition? how it works?

Anonymous — Tue, 14 Oct 2014 15:26:18 GMT

output 0,005

Re: if condition? how it works?

Anonymous — Tue, 14 Oct 2014 15:28:49 GMT

hi,

if(0,005>0) then 0,005 else 0

output 0,005

Re: if condition? how it works?

MarcoWedel — Tue, 14 Oct 2014 16:26:34 GMT

Are these Typos, or is this your actual expression?

if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)

regards

Marco