Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
lejours88
Contributor

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
Highlighted
qlikviewwizard
Honored Contributor II

Re: Get some part of data

Capture.PNG

Highlighted
karthikeyan1504
Contributor III

Re: Get some part of data

Hi,

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

Highlighted
Digvijay_Singh
Honored Contributor III

Re: Get some part of data

try this -

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

Highlighted
sasiparupudi1
Honored Contributor III

Re: Get some part of data

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

Highlighted
Partner
Partner

Re: Get some part of data

Also Try like this:

Put below expression In variable:

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

Highlighted
pratap6699
Contributor

Re: Get some part of data

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

Highlighted
pratap6699
Contributor

Re: Get some part of data

=Left('A_B_C_D',5)