topic Re: Get some part of data in QlikView

Get some part of data

Anonymous — Mon, 28 Sep 2015 02:45:42 GMT

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 — Mon, 28 Sep 2015 03:44:09 GMT

karthikeyan1504 — Mon, 28 Sep 2015 03:45:47 GMT

Hi,

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

Digvijay_Singh — Mon, 28 Sep 2015 04:35:36 GMT

try this -

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

sasiparupudi1 — Mon, 28 Sep 2015 06:12:48 GMT

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

nagarjuna_kotha — Mon, 28 Sep 2015 06:36:05 GMT

Also Try like this:

Put below expression In variable:

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

pratap6699 — Mon, 28 Sep 2015 10:09:27 GMT

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

pratap6699 — Mon, 28 Sep 2015 10:13:49 GMT

=Left('A_B_C_D',5)