Count on specific Field Content

Fri, 20 Nov 2020 18:02:30 GMT

Is there a way to extract a specific text portion of a field and conduct a count on that specific item? What would the syntax be and where would it appear (load script or sheet object)?

Also when extracting that specific text can I import it into a separate field?

Field Content Example: Apple Tree , Orange Tree, Lilac Tree

I would want to extract the word 'Tree' into a separate field and also count the different varieties of apple, orange, and lilac

Re: Count on specific Field Content

Gysbert_Wassenaar — Thu, 19 Mar 2015 12:40:37 GMT

LOAD

MyField,

if(substringcount(MyField, 'Tree'),'Tree') as FieldThatContainsTheValueTree,

if(substringcount(MyField, 'Tree'), trim(replace(MyField, 'Tree',''))) As TreeVariety

FROM ...

In the front end you can create a chart object with TreeVariety as dimension and count(TreeVariety) as expression.

topic Re: Count on specific Field Content in QlikView

Count on specific Field Content

Re: Count on specific Field Content