SAP BW: hide value of compounded infoobject in Qlik

[TomBond77]

Good Day

I am very new to Qlik.

We uploaded BW data to QlikSense. In BW Query (formerly BEx) I have set the properties on infoobject 0CO_AREA to "no display". This infoobject is the compounded one of 0COSTCENTER.

Anyway, in Qlik this property seems to be ignored.

Now I need the right script to hide this value in Qlik.

Example:

0COSTCENTER:

1000/5000000001 -> 5000000001.

Any ideas?

Thanks

Tom

[martinpohl]

Hi,

a filter is always a filter for a dialog user, in tables all datas are in.

I suggest:

load

subfield(0COSTCENTER,'/',2) as 0COSTCENTER,

-> delimitted by the string / you only get the second value

Regards

[TomBond77]

Thanks Martin

Unfortunately it is not working.

subfield(SCOSTCENT,'/',2) as [Cost Center ID] results in '-'.

Reason: There is no '/'. The first 4 places are the compounded char. How do we script to show only the result after the 4th place of the left? Tried to find something with LEFT and an offset, but without success.

Can you help on this?

Regards

Tom

[TomBond77]

the compounded combination is shown as:

10005000000001

The first four figures are the cost area.

[TomBond77]

I need: 5000000001

[TomBond77 · Accepted solution]

got it:

Right(Trim(SCOSTCENT), Len(Trim(SCOSTCENT)) -6) as [Cost Center ID],