If Condition

[qlikview979]

Hi Experts,

this is the condition in EXcel

if(ZYME<=CDMS,(ZYME/CDMS)+100%,(ZYME-CDMS)/ZYME)

in this how can write in qlikview  front end

Specially 100% how can i calculate it

Regards,

Mahesh

[MindaugasBacius]

Write like this:

if(ZYME<=CDMS,(ZYME/CDMS)+1,(ZYME-CDMS)/ZYME)

And then in the Properties:

[trdandamudi]

Can you please share some sample data along with the expected output...

[qlikview979]

Hi Bro ,

I am doing this is this correct

if(ZYME<=CDMS,(ZYME/CDMS)+'#,##0',(ZYME-CDMS)/ZYME)

[qlikview979]

Hi

CDMS  ZYME

10          15

15          10

15           15

Regards,

Mahesh

[MindaugasBacius]

if(ZYME<=CDMS,(ZYME/CDMS)+'#,##0',(ZYME-CDMS)/ZYME)

Write instead:

if(ZYME<=CDMS,(ZYME/CDMS)+1,(ZYME-CDMS)/ZYME)

[qlikview979]

Hi Bro your Condition showing Wrote %

[qlikview979]

I  given Sample data please check once

[qlikview979]

its showing 200%

pls find this file

[trdandamudi]

May be something like below: