topic Re: Remove values after minus symbol in QlikView

Remove values after minus symbol

Anonymous — Tue, 13 Jan 2015 17:22:35 GMT

Hi,

I'm loading data from sample.qvd file where from the values are coming as illustrated below in the table format "Current Output" but I need output like "Required Output" column.

Current Output	Required Output
Parent-ABC-111	Parent-ABC-111
Parent-ABC-111-AB0	Parent-ABC-111
Parent-ABC-111-AB1	Parent-ABC-111

Regards,

Re: Remove values after minus symbol

jpapador — Tue, 13 Jan 2015 17:25:44 GMT

If you always want the first three you could do something like the following:

Subfield([Current Output], '-', 1) & '-' & Subfield([Current Output], '-', 2) & '-' & Subfield([Current Output], '-', 3) as [Required Output]

Re: Remove values after minus symbol

Anonymous — Tue, 13 Jan 2015 17:31:12 GMT

Or maybe something like this :

= left ( 'Parent-ABC-111-AB0' , index ( 'Parent-ABC-111-AB0' , '-' , 3) -1 )