topic Re: substringcount(Concat( - present multiple records , how to present the exact value i picked? in QlikView

substringcount(Concat( - present multiple records , how to present the exact value i picked?

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

Hi all,

I tried to set a dynamic report

i created two inline tables _Dimensions and _Measures

_Dimensions table contain the following values

Group
A_Group

B_Group

i set a condition on each =SubStringCount(Concat(_Dimensions, '|'), 'X')

when X = Group/A_Group/B_Group respectively

but when i pick A_Group or/and B_Group the Group is also shown

how could i pick the exact value that i picked instead of *Group* values

Anil_Babu_Samineni — Tue, 25 Dec 2018 08:27:10 GMT

Where are you trying this? Are you trying in Text box, IF so based on condition what are you expecting to see from Dimension table?

shahafei2 — Tue, 25 Dec 2018 08:34:03 GMT

i created a dynamic report with straight table object

and the user should pick the required fields base on two list box

_Dimensions

_Measures

When the _Dimensions values are fields under the Dimensions tab in the straight table object (Contains the conditions

=SubStringCount(Concat(_Dimensions, '|'), 'X') )

and the _Measures values are used for the expression with the same conditions

(=SubStringCount(Concat(_Measures, '|'), 'Y'))

as i wrote the problem is that when i pick one of the "*_Group" values the condition is picking the "Group" field as well

Anil_Babu_Samineni — Tue, 25 Dec 2018 12:02:05 GMT

Not sure, Still i understand the problem. Are you working for AD-hoc report? If so, Kindly post your sample application.

shahafei2 — Tue, 25 Dec 2018 12:16:41 GMT

Thank you,

I didn't know that its called AD-hoc report

I found the problem in the syntax

i wrote

=SubStringCount(Concat(_Dimensions, '|'), 'Group')

instead of

=SubStringCount('|' & Concat(distinct _Dimensions, '|') & '|', '|Group|')

Anil_Babu_Samineni — Tue, 25 Dec 2018 12:18:58 GMT

Cool, You got the work around. Please close this thread, If you resolve by your self flagging "Correct Answer" from your Answer.