Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

Need help in Correcting the expression

Hi ,

I have to get done Cell colored in green for  top 5 percentage values

Expression:    

  if(Dimensionality()=1 ,

if(rank(sum({<Year={$(vMaxCY)}>}Volume)
/
(sum({<Year={$(vPreCY)}>}Volume))-1)<=5,green(),rgb(201, 219, 189)

),rgb(201, 219, 189)  )

Expression is Working  FineCapture.PNG

But when i tried to expand any value the color getting disappear 

Capture1.PNG

So what correction should i need to do in my expression so that the color of Dimensionality 1 should remain green (861.08,49.08,34.52,14.55,9.73),even though the values are expanded  . 

 

 

Thanks

 

3 Replies

Re: Need help in Correcting the expression

Would you be able to share a sample to take a look at this

kunkumnaveen
Valued Contributor

Re: Need help in Correcting the expression

Hello Sunny,

Please find the attachment ..

In pivot  Table 

Dimensions:

1)Category 

2)Brand

Expression

Sum(Volume)

Now Color top 5 Volumes Cells ...Category Wise in green color

 

Capture.PNG

The Cell Color of Category should remain Green  even though if we expand the group dimension (Brand )

which i am not able to get Capture1.PNG

 

 

kunkumnaveen
Valued Contributor

Re: Need help in Correcting the expression

Hello Sunny,

Please find the attachment ..

In pivot  Table 

Dimensions:

1)Category 

2)Brand

Expression

Sum(Volume)

Now Color top 5 Volumes Cells ...Category Wise in green color

 

Capture.PNG

The Cell Color of Category should remain Green  even though if we expand the group dimension (Brand )

which i am not able to get Capture1.PNG