topic Re: Count For Pick and WildMatch in QlikView

Count For Pick and WildMatch

Tue, 10 Oct 2017 07:54:05 GMT

Unable to recount the word after it have been count in bar chart.

Labels
ITSDM; UAT
ITSDM
ITSDM
ITSDM; UAT
ITSDM; UAT

=Pick(WildMatch(Labels, '*ITSDM*', '*UAT*'), 'ITSDM', 'UAT')

The bar chart should be

ITSDM 5

UAT 3

But the error now is

ITSDM 5

UAT 0

Re: Count For Pick and WildMatch

swuehl — Tue, 10 Oct 2017 08:01:46 GMT

You can't group your records into two groups of different dimensional values at the same time.

Use Subfield() in your load script to separate your concatenated values into separate records

LOAD

Subfield(FIELD, ';') as FIELD,

....

Re: Count For Pick and WildMatch

swuehl — Tue, 10 Oct 2017 08:02:56 GMT

Alternatively, use multiple expressions that filter your records instead of a dimension.

Re: Count For Pick and WildMatch

tresB — Tue, 10 Oct 2017 08:19:11 GMT

Or, you may try like:

Re: Count For Pick and WildMatch

Tue, 10 Oct 2017 08:27:56 GMT

How to i combine it with a column that is based on month?

Re: Count For Pick and WildMatch

tresB — Tue, 10 Oct 2017 08:32:14 GMT

If this requirement is something not very adhoc in nature, you should deal with it in the script. Could you share a real representative sample (like you said month column association), to help better ?

Re: Count For Pick and WildMatch

MarcoWedel — Wed, 11 Oct 2017 21:56:38 GMT

Hi,

not as a recommended solution but to show what could be done using chart expressions only without hard coded label values:

I guess the best approach to this problem would be to create a [Label] field from your [Labels] values using the 2-parameter Subfield() function like Stefan already suggested.

hope this helps

regards

Marco