Discussion Board for collaboration related to QlikView Deployment.
How to split the reminder call values in separate columns of a pivot table.
Can anybody Explain with screen shots?
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
in same application complaint no also available.
Go to Solution.
use this for color
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.
Have a look at concat()
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".
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?
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
I will show only Column Text and Greater than 2 values should be red colour.
The reminder calls depending on ComplaintNo.