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: 
soniasweety
Master
Master

include if

Hi all,

I have expression  like below but I want to write the if condition  in backend how can I write?

this is original expression  = Only({$-<compltedate={"*"}>}id)

tried in script   if( Only({$-<compltedate={"*"}>},'Yes','No') as NewID

what is wrong in this expression can anyone give suggestions?

14 Replies
prma7799
Master III
Master III

Put value in Variable like

vNewVariable = Only({$-<compltedate={"*"}>}id)


And use in front end like


if( $(vNewVariable ) ,'Yes','No')

soniasweety
Master
Master
Author

not working

after using the variable

giving error when I debug it is showing like this   --error  ')' expected

est.PNG

prma7799
Master III
Master III

Can you please share some sample app.

Chanty4u
MVP
MVP

or else

try in simple way   which field your excluding null use that in same expression like below

=Aggr(only({<Flag1={0},Status-={'passed'}, Completedate-={' '}>} if(duration>=Critical,id,null())),id,Name)

soniasweety
Master
Master
Author

yes chanty it worked thank u