alternate function for Find in qlikview?

[khasimvali85]

Hi Community,

What is the alternate function for find in qlikview?

Regards,

Khasim.

[jpenuliar]

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

You could be looking for

Match()

Subfield()

Pick()

[khasimvali85]

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]

This one should help:

Find a string into the values | Qlik Community

[robert_mika]

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]

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.

[PrashantSangle]

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