Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator 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
ashfaq_haseeb
Champion III
Champion III

Hi,

use this for color

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

Regards

ASHFAQ

View solution in original post

16 Replies
avinashelite

Hi,

Can you please provide the sample data and your exact requirement 

Not applicable

could you elaborate it a bit

deepakqlikview_123
Specialist
Specialist

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

ashfaq_haseeb
Champion III
Champion III

Have a look at concat()

Regards

ASHFAQ

IAMDV
Master II
Master II

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
Creator II
Creator II
Author

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.

ashfaq_haseeb
Champion III
Champion III

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
Creator II
Creator II
Author

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

use this for color

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

Regards

ASHFAQ