topic Re: how to concatenate fields? in QlikView

how to concatenate fields?

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

Hi All,

i have one inline table and groups

im using conditional dimension statement to concatenate the inline table value is selected groupneed to be display in chart

im using below expressions . please help us

=SubStringCount('|' & GetFieldSelections(Groups_List, '|') & '|', '|DimOverviewICATMGroup|')

(GetSelectedCount(Groups_List)='[ICATM_Group]') and SubStringCount('|' & Concat(Groups_List, '|')& '|','|DimOverviewICATMGroup|')

please help us ASAP

Thanks in Advance

sunny_talwar — Thu, 13 Dec 2018 19:17:17 GMT

Not sure I understand the issue? What is the problem you are running into?

SNR1 — Thu, 13 Dec 2018 19:27:25 GMT

hi Sunny,

when i select a filed like icatm group in my inline table groups list then

a dimension called dimoverviewicatm group should be selected in my chart dimension is added like conditional dimension

i.e if i select icatm from group list then the dimension or group should reflect in my table .

Thanks in Advcance