Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
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
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Write like this:

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


And then in the Properties:

Screenshot_1.jpg

trdandamudi
Master II
Master II

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

qlikview979
Specialist
Specialist
Author

Hi Bro ,

I am doing this is this correct

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

qlikview979
Specialist
Specialist
Author

Hi

CDMS  ZYME

10          15

15          10

15           15

Regards,

Mahesh

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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


Write instead:

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

qlikview979
Specialist
Specialist
Author

Hi Bro your Condition showing Wrote %

qlikview979
Specialist
Specialist
Author

I  given Sample data please check once

qlikview979
Specialist
Specialist
Author

its showing 200%

pls find this file

trdandamudi
Master II
Master II

May be something like below:

If_FromExcel_To_Qlik.jpg