Get some part of data

[Anonymous]

Hi I have a question,

i have a set analysis like this

=Sum({$<Filter={"$(vFilter)"}>} Data)

vFilter value has format data like this

ex : A_B_C_D

I want to get only A_B_C and cut the D.

So the set analysis will be like this :

=Sum({$<Filter={"A_B_C"}>} Data)

Is it possible to make it ?

Thanks

[qlikviewwizard]

[karthikeyan1504]

Hi,

Is the format & characters count is fixed all the time?

[Digvijay_Singh]

try this -

=Sum({$<Filter={"$(=left($(vFilter),5))"}>} Data)

[sasiparupudi1]

left('A_B_C_D',Index('A_B_C_D','_',-1)-1)

[nagarjuna_kotha]

Also Try like this:

Put below expression In variable:

=Replace(Filter,'A_B_C_D','A_B_C')

[pratap6699]

subfield(filter,'_',3)as new_filter

[pratap6699]

=Left('A_B_C_D',5)