topic Re: Result in required format in QlikView

Result in required format

Thu, 27 Aug 2015 16:41:42 GMT

Input values are in below scenario,

Field1: P/P/R/R

Field2: 100/100/200/200

Required output in below format,

Field1: P/R

Field2:100/200

Please suggest how to trim those values to get above output format

Re: Result in required format

kaushiknsolanki — Thu, 27 Aug 2015 16:47:14 GMT

Hi,

Do you mean that your data is in below format.

Field1,Field2

P,100

R,200

If yes then try this.

Load Distinct Field1,Field2

From xyz;

Regards,

Kaushik Solanki

Re: Result in required format

Thu, 27 Aug 2015 17:00:19 GMT

No, I have to trim this values at UI/presentation level and display as below format

field1: P/R

field2: 100/200

Not like (P/P/R/R, 100/100/200/200)

Re: Result in required format

kaushiknsolanki — Thu, 27 Aug 2015 17:05:27 GMT

Hi,

Tell me one thing, is your field has only 1 record in this case? Please provide some sample data for more clarification.

Regards,

Kaushik Solanki

Re: Result in required format

Thu, 27 Aug 2015 17:08:42 GMT

yes, field1 contains 1 value i.e P/P/R/R and field2 contains 1 value i.e 100/100/200/200

Now , we have to display o/p as P/R for field1 & 100/200 for field2.

Re: Result in required format

settu_periasamy — Thu, 27 Aug 2015 17:25:05 GMT

Hi,

Try this

=SubField('P/P/R/R','/',1)&'/'&SubField('P/P/R/R','/',3)

=SubField('100/100/200/200','/',1)&'/'&SubField('100/100/200/200','/',3)

Re: Result in required format

kaushiknsolanki — Thu, 27 Aug 2015 17:29:31 GMT

Hi,

Have a look at the attached example.

This will work for only 1 record in table, but it can work for any numbers of sub value (4 in your example)

Regards,

Kaushik Solanki