How to split the values in separate columns of a pivot table?

[khasimvali85]

Hi,

     How to split the reminder call values in separate columns of a pivot table.

Can anybody Explain with screen shots?

Hi,

     Thanks for approaching I am attaching qvw file and Screen shot  below.

In this table having ASC_ID, ReminderCOunt, ComplaintNo and ReminderCalls .

In Reminder Calls i wanna Split each Column in ReminderCalls and to find Greater than 2 values should be Red Colour.

I wanna add another column like greater than 2 calls = com[plaint no will show

Ex:

Calls;          Comp.No:

1,1,2               1,1,99889989

2,2,1               8855434,6434533,1

in same application complaint no also available.

[khasimvali85]

Hi Ashfaq,

                         Thanks for giving the solution it's Awesome Expression.It Works fine.

Regards,

Khasim.

[ashfaq_haseeb]

Hi,

Check if this helps

Regards

ASHFAQ

[khasimvali85]

HI Ashfaq,

          Not like that i wanna disply complaint no

[khasimvali85]

Hi ASFAQ,

         See my QVW Application RemCall.QVW you can understand

[khasimvali85]

HiAshfaq,

i am giving table below i wanna disply complaint no >2 Calls

9159	0	0
9158	1	1	GOR1007140068	1	1
9156	2	2	GUR0907140255;GUR1407140305	1;1	1;1
9155	2	2	NAG1207140071;NAG1407140068	1;1	1;1
9153	3	11	BAN0407140002;BAN0907140257;BAN1207140081;BAN1307140037;BAN1407140113;BAN1407140269;BAN1507140129;BAN1507140272;BAN1707140027	1;1;1;1;1;1;1;2;2	1;1;1;1;1;1;1;2;2
9152	0	0
9151	1	1	NAG0807140075	1	1

[khasimvali85]

Hi Ashfaq,

9158	1	1	GOR1007140068	1	1
9156	2	2	GUR0907140255;GUR1407140305	1;1	1;1
9155	2	2	NAG1207140071;NAG1407140068	1;1	1;1
9153	3	11	BAN0407140002;BAN0907140257;BAN1207140081;BAN1307140037;BAN1407140113;BAN1407140269;BAN1507140129;BAN1507140272;BAN1707140027	1;1;1;1;1;1;1;2;2	1;1;1;1;1;1;1;2;2

Display Complaint Nos only >2 Calls

9153

3

11

BAN0407140002;BAN0907140257;BAN1207140081;BAN1307140037;BAN1407140113;BAN1407140269;BAN1507140129;BAN1507140272;BAN1707140027

1;1;1;1;1;1;1;2;2

1;1;1;1;1;1;1;2;2

[ashfaq_haseeb]

Use this formulae

If(count(RemComplaintNo)>2,Concat({< ReminderDate= >} DISTINCT RemComplaintNo,';'),'')

Regards

ASHFAQ