topic Re: If Condition in QlikView

If Condition

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: If Condition

MindaugasBacius — Fri, 23 Sep 2016 06:55:48 GMT

Write like this:

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

And then in the Properties:

Re: If Condition

trdandamudi — Fri, 23 Sep 2016 06:56:03 GMT

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

Re: If Condition

qlikview979 — Fri, 23 Sep 2016 06:57:23 GMT

Hi Bro ,

I am doing this is this correct

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

Re: If Condition

qlikview979 — Fri, 23 Sep 2016 07:00:45 GMT

CDMS ZYME

10 15

15 10

15 15

Regards,

Mahesh

Re: If Condition

MindaugasBacius — Fri, 23 Sep 2016 07:01:10 GMT

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

Write instead:

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

Re: If Condition

qlikview979 — Fri, 23 Sep 2016 07:01:27 GMT

Hi Bro your Condition showing Wrote %

Re: If Condition

qlikview979 — Fri, 23 Sep 2016 07:02:17 GMT

I given Sample data please check once

Re: If Condition

qlikview979 — Fri, 23 Sep 2016 07:10:14 GMT

its showing 200%

pls find this file

Re: If Condition

trdandamudi — Fri, 23 Sep 2016 07:12:30 GMT

May be something like below:

Re: If Condition

dmac1971 — Fri, 23 Sep 2016 07:13:16 GMT

Done in this file.

Re: If Condition

tamilarasu — Fri, 23 Sep 2016 07:15:43 GMT

Hi Mahesh,

May be try this,

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