topic Re: need help(expression) in QlikView

need help(expression)

siva_boggarapu — Wed, 18 Jun 2014 10:09:41 GMT

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

MK_QSL — Wed, 18 Jun 2014 10:22:02 GMT

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 — Wed, 18 Jun 2014 10:30:15 GMT

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

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

siva_boggarapu — Wed, 18 Jun 2014 10:31:31 GMT

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 — Wed, 18 Jun 2014 10:36:01 GMT

kindly provide sample apps or data file..

sasikanth — Wed, 18 Jun 2014 10:46:32 GMT

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