topic Re: multiple conditions for one field in QlikView

multiple conditions for one field

Wed, 04 Nov 2015 02:27:19 GMT

Hi everyone, I am surveying if QlikView fits our requierments.

We have a field contains different information.

For example, an "Skills" field,

and the content would be 'Java;C#;C++ ','Java, PHP, JavaScript', or 'Java;C++'.

We might try to find out who has Java in the skills field,

or anything starts with 'C'.

Does it possible in QlikView?

I try to scan the documents but can't actually find the answer.

Thanks for your kindly reply in advance.

BR,

Dorothy

Re: multiple conditions for one field

hic — Wed, 04 Nov 2015 10:18:02 GMT

Yes of course this is possible. I would use the SubField() function that splits a list of values like you have, into several records in the data. This way each skill will end up on its own row, and be searchable using e.g. C* as search string.

example:

Subfield(Skills, ',') as Skill

HIC

Re: multiple conditions for one field

tamilarasu — Wed, 04 Nov 2015 10:30:43 GMT

Hi Dorothy,

I guess you need to use WildMatch function. Something like If(Wildmatch(Skills, 'Java*','C*'),'Yes','No')

Re: multiple conditions for one field

Mark_Little — Wed, 04 Nov 2015 10:42:06 GMT

Hi,

Yes this would be possible, there is a number of different approaches to see these in the dashboard.

You could flags in the data load to say if Skills like 'C*'

or you could set analysis or search boxes using wild card or Fuzzy searches.

All really depends on what you are wanting to see and where.

Hope this helps.

Mark

Re: multiple conditions for one field

marcus_sommer — Wed, 04 Nov 2015 12:02:13 GMT

In addition to the answer from hic it might be helpful to categorize those skills per mapping in an extra field instead of using from search-expressions: Mapping … and not the geographical kind.

- Marcus

Re: multiple conditions for one field

Thu, 05 Nov 2015 07:30:31 GMT

Thank you so much for the useful answers.