topic Re: alternate function for Find in qlikview? in QlikView

alternate function for Find in qlikview?

khasimvali85 — Tue, 03 Feb 2015 13:03:32 GMT

Hi Community,

What is the alternate function for find in qlikview?

Regards,

Khasim.

Re: alternate function for Find in qlikview?

jpenuliar — Tue, 03 Feb 2015 13:38:28 GMT

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

You could be looking for

Match()

Subfield()

Pick()

Re: alternate function for Find in qlikview?

khasimvali85 — Tue, 03 Feb 2015 13:55:36 GMT

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.

Re: alternate function for Find in qlikview?

jpenuliar — Tue, 03 Feb 2015 14:02:08 GMT

This one should help:

Find a string into the values | Qlik Community

Re: alternate function for Find in qlikview?

robert_mika — Tue, 03 Feb 2015 16:02:03 GMT

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.

Re: alternate function for Find in qlikview?

khasimvali85 — Wed, 04 Feb 2015 03:55:19 GMT

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?

PrashantSangle — Wed, 04 Feb 2015 04:12:04 GMT

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