Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

If Condition

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

11 Replies
Specialist III
Specialist III

Write like this:

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


And then in the Properties:

Screenshot_1.jpg

Master II
Master II

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

Specialist
Specialist

Hi Bro ,

I am doing this is this correct

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

Specialist
Specialist

Hi

CDMS  ZYME

10          15

15          10

15           15

Regards,

Mahesh

Specialist III
Specialist III

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


Write instead:

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

Specialist
Specialist

Hi Bro your Condition showing Wrote %

Specialist
Specialist

I  given Sample data please check once

Specialist
Specialist

its showing 200%

pls find this file

Master II
Master II

May be something like below:

If_FromExcel_To_Qlik.jpg