How to read the data field with pipe '|DATA|' in qlikview and display in pie chart to expected result

[QLIK_PK]

I have the below field in the database, where I need to create a pie chart with with DATA vs DOMAIN 

1|DATA|-|Def|-

3|DATA|-|dafsdf|-

4|DATA|-|sdfr|-

7|DATA|-|fwef|-

6|ABD|DOMAIN|-||-

9|EFDS|Other||-|-

The chart should reads from the abobe table (Sample) to differentiate with and display the below result (data vs domain) as

DATA as 66%

DOMAIN as 17%

and Other should name as NA in 17%

[JustinDallas]

We need a little bit more information.  Is the pipe coming from the datasource and is part of the value in the field?  Or is it an inline table or CSV that is pipe delimited?

[QLIK_PK]

Yes. Pipe is coming from the database