Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

How the write the expression

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

 

 

3 Replies
Highlighted
Partner
Partner

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)

Highlighted

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.

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.