topic Re: Can Subfield work inside Set Analysis? in QlikView

Can Subfield work inside Set Analysis?

dennysetiawan — Wed, 25 Nov 2020 16:16:04 GMT

Dear Expert,

I have a field named ActionCode which contains:

ZC/HRQCLNT/01

ZC/HRQCLNT/02

ZC/HRQCLNT/03

ZC/HRQCLNT/04

Now i want to Sum (Sales) where ActionCode containins number 01 and 03 using SubField function. So the function should like: SubField(ActionCode, '/', 3).

I've tried several ways like:

Sum({<ActionCode={$(=SubField(ActionCode,'/',3))={'01,'03'}}>} Sales)

Sum({<ActionCode={$(=Wildmatch(SubField(ActionCode,'/',3),'01','03'))}>} Sales)

But still not successfully yet.

Can anyone help me? Thank you.

Re: Can Subfield work inside Set Analysis?

marcus_malinow — Wed, 28 Jun 2017 08:48:17 GMT

Hi Danny,

I don't think in this instance subfield is necessary.

e.g.

Sum({<ActionCode={"*/01", "*/03"}>} Sales)

Marcus

Re: Can Subfield work inside Set Analysis?

tresB — Wed, 28 Jun 2017 08:51:54 GMT

Try like:

Sum({<ActionCode={"=Wildmatch(SubField(ActionCode,'/',3),'01','03')" }>} Sales)

Re: Can Subfield work inside Set Analysis?

dennysetiawan — Wed, 28 Jun 2017 08:56:31 GMT

Hi Marcus,

Thank you for reply.

I use SubField because the data is separated by the mark '/' and taken is the 3rd data from the separator. If using your solution, there may be the same data in the other separator. And for some other cases, I have to use SubField.

Can I implemented SubField inside Set Analysis?

Thank you.

Re: Can Subfield work inside Set Analysis?

dennysetiawan — Wed, 28 Jun 2017 09:13:59 GMT

Thank you Tresesco