topic Re: Need help in Correcting the expression in QlikView

Need help in Correcting the expression

kunkumnaveen — Thu, 25 Apr 2019 11:20:32 GMT

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 Fine

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

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

Re: Need help in Correcting the expression

sunny_talwar — Thu, 25 Apr 2019 11:50:54 GMT

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

Re: Need help in Correcting the expression

kunkumnaveen — Thu, 25 Apr 2019 12:18:14 GMT

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

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

which i am not able to get

Re: Need help in Correcting the expression

kunkumnaveen — Thu, 25 Apr 2019 12:18:18 GMT

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

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

which i am not able to get