Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
What is the alternate function for find in qlikview?
Regards,
Khasim.
Can you be more specific on what you want to "Find",
You could be looking for
Match()
Subfield()
Pick()
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.
This one should help:
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.
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.
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