Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

need help(expression)

courseid1= {1,2,3..... 199}

Courseid2={1,2,4,5....180}

now  i have to check wether both fields having   coursesid's  -{163},{164}  or bot?

i have to find out  ?

please help me

Regards

Siva

5 Replies
MK_QSL
MVP
MVP

You can create a flag something like below in script

IF (courseid1 = 163 or 164, 'Yes','No') as Flag

and

IF (courseid2 = 163 or 164, 'Yes','No') as Flag

sujeetsingh
Master III
Master III

First you need to concatenate or join the two courseID's and then use as

if(wildmatch(courseID1,'-163','164'),'Yes','No')

siva_boggarapu
Creator II
Creator II
Author

hi manish,

thanks for response

but   my case   creating flag is not work out.. because to extended i have some other calxulation s ae there

after matching 163, 164 coursieds in both the fields then i have to exclude some other courses{1,2,3,4} .

reply me,

thanks

siva

MK_QSL
MVP
MVP

kindly provide sample apps or data file..

sasikanth
Master
Master

Hi siva

you can use that if condition in exp level also

please post your full requirement and conditions

then you will get response fast