Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
khasimvali85
Contributor II

alternate function for Find in qlikview?

Hi Community,

What is the alternate function for find in qlikview?

Regards,

Khasim.

Tags (1)
6 Replies
jpenuliar
Valued Contributor III

Re: alternate function for Find in qlikview?

Can you be more specific on what you want to "Find",

You could be looking for

Match()

Subfield()

Pick()

khasimvali85
Contributor II

Re: alternate function for Find in qlikview?

Hi Jonathan,

Thanks for replay my requirement is

Example i am explaining

I have above 10 columns in my excel file

i want to find data from 3 columns so i want to find one column data if its find  'OK' not find goes to second column

if find data in second column 'OK' if not found goes to third column

if find the data in third column OK not find 'NotOK',


and how to implement in Qlikview?

see below attachment in excel formula for the pertecular brand.



Regards,

Khasim.

jpenuliar
Valued Contributor III

Re: alternate function for Find in qlikview?

Re: alternate function for Find in qlikview?

That is a hell of a lot formula in Excel.

This could be done in simple way (in Excel and Qlikview)

Could you post your list of data?

The one you are searching for in each cell.

khasimvali85
Contributor II

Re: alternate function for Find in qlikview?

Hi Robert,

i am added excel data find above

i want to find out data from 3 columns from given data the columns are 'DEALER', 'call_from', 'Name'.

and find the as per excel formula.

how can i achive this?

Thanks in Advance

Regards,

Khasim.

Re: alternate function for Find in qlikview?

Hi,

Write simple if else statement in script

Try like

if(wildmatch(column1,'*SearchData*'),'OK',if(wildmatch(column2,'*SearchData*'),'OK',if(wildmatch(column3,'*SearchData*'),'OK','Not OK')))

Note: Use wildmatch() if you required to do non-case sensitive search

of use match() if you required to do case sensitive search

use wild character * if you search data in between your serach String.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser