multiple conditions for one field

[#1]

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

[hic]

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

[tamilarasu · Accepted solution]

Hi Dorothy,

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

[Mark_Little]

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

[marcus_sommer]

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

[#6]

Thank you so much for the useful answers.