Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lejours88
Creator
Creator

Get some part of data

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

7 Replies
qlikviewwizard
Master II
Master II

Capture.PNG

karthikeyan1504
Creator III
Creator III

Hi,

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

Digvijay_Singh

try this -

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

sasiparupudi1
Master III
Master III

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Also Try like this:

Put below expression In variable:

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

pratap6699
Creator
Creator

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

pratap6699
Creator
Creator

=Left('A_B_C_D',5)