topic Re: How the write the expression in QlikView

How the write the expression

kunkumnaveen — Wed, 11 Sep 2019 09:46:47 GMT

Hello All,

I had atttached the image ,Please find the attachment

I need to Color the cell with max percentage of each model,

For example from multiple model values i had selected CRETA, For Creta i need to color cell with 31% percentage

Expression for %:

sum({<Year={2018}>}[Volume])/sum({<Year={2018}>}total<[Model]>[Volume])

Thanks

Re: How the write the expression

StarinieriG — Wed, 11 Sep 2019 10:19:27 GMT

Hi,

try with something like this:

If(Rank(total sum({<Year={2018}>}[Volume])/sum({<Year={2018}>}total<[Model]>[Volume]))<=Count(total distinct Model & Year),COLOR)

Re: How the write the expression

sunny_talwar — Wed, 11 Sep 2019 11:53:08 GMT

You can try a color expression like this

If(Max(TOTAL <Model> Aggr(Sum({<Year = {2018}>} [Volume]), Price, Model, Liters, Fuel, Transmission)) = Sum({<Year = {2018}>} [Volume]), LightRed())

Here if you create this expression.... you should see the Max value of the Model repeating for each of the row...

Max(TOTAL <Model> Aggr(Sum({<Year = {2018}>} [Volume]), Price, Model, Liters, Fuel, Transmission))

I did not use the denominator in the expression because it is redundant and will have the same value for all the Model.

Re: How the write the expression

Brett_Bleess — Tue, 24 Sep 2019 12:44:38 GMT

Naveen, did either of the posts help you with your issue? If so, please be sure to circle back and give them credit by using the Accept as Solution button on any posts that were helpful in getting the solution you needed. If you still need further help with things, leave an update of where things stand for us.

Regards,
Brett