Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

khasimvali85
Contributor II

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

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.

1 Solution

Accepted Solutions

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

Hi,

use this for color

=if(FindOneOf(Concat(AGGR(SUM(ReminderCall),RemComplaintNo),';'),23456)>2,lightred())

Regards

ASHFAQ

16 Replies

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

Hi,

Can you please provide the sample data and your exact requirement 

Not applicable

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

could you elaborate it a bit

deepaktibhe
Valued Contributor

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

u can use pivot table like cross tables u can drag entire column to rows so that u will see all values from column into 1 row.

thanks

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

Have a look at concat()

Regards

ASHFAQ

dvqlikview
Honored Contributor II

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

Hi,

As suggested by everyone above, please explain your question clearly with a screenshot if possible or attach an example. Not sure what you mean by "Call Value", I assume you meant "Cell Value".

DV

www.QlikShare.com

khasimvali85
Contributor II

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

Hi Ashfaq,

               Already i used Concat() function,and the values are displaying correct but i am not finding in this values greater than 2 values should be in red colour.can give any suggession for this?

Regards,

Khasim.

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

Hi,

Your files are corrupted I cannot download it.

You cannot control individual value color, instead if the vale is grater then 2 then you can color entire column text or background color.

have a look at attached application

Regards

ASHFAQ

khasimvali85
Contributor II

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

Hi Ashfaq,

               I will show only Column Text and Greater than 2 values should be red colour.

Example:

The reminder calls depending on ComplaintNo.

ReminderCall

2,2,2,4

3,4,5,2

4,1,3,3

Regards,

Khasim.

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

Hi,

use this for color

=if(FindOneOf(Concat(AGGR(SUM(ReminderCall),RemComplaintNo),';'),23456)>2,lightred())

Regards

ASHFAQ

Community Browser