Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
use this for color
=if(FindOneOf(Concat(AGGR(SUM(ReminderCall),RemComplaintNo),';'),23456)>2,lightred())
Regards
ASHFAQ
Hi,
Can you please provide the sample data and your exact requirement
could you elaborate it a bit
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
Have a look at concat()
Regards
ASHFAQ
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
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.
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
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.
Hi,
use this for color
=if(FindOneOf(Concat(AGGR(SUM(ReminderCall),RemComplaintNo),';'),23456)>2,lightred())
Regards
ASHFAQ