topic Re: Pivot table top 5 values colour change in QlikView

Pivot table top 5 values colour change

Thu, 13 Nov 2014 03:54:16 GMT

Hi Qlikers,

Please find the attachment.

I have pivot table drawn in qvw file.

now I want in fruit and reason desc null values should go down and last .

for fruit the order is Mango,Guava,grape etc....

now I want to change top 5 values colur should be green and those should come in descending order

kindly help me .

its an urgent requirement.

ASAP.

Thanks in advance.

SergeyMak — Thu, 13 Nov 2014 04:10:09 GMT

Hi Sampath,

Please show how you can get the descending order in pivot table for all Fruits and Categories in Excel file.

I ask you to do it because as I see, It could be done, only by One fruit by categories or for One category by Fruits.

To move Null values down just go to Sort and change the sort order to A->Z for both dimension.

Regards,

Sergey

SergeyMak — Thu, 13 Nov 2014 04:13:00 GMT

To color TOP-5 in green use the following expression for background of Expression

if(Rank(Sum(Data))<=5,green(),white())

PFA

sujeetsingh — Thu, 13 Nov 2014 04:37:19 GMT

Sergy has provided you one way, you can make this more nested for assigning different colours to all top 5