Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color Wizard -->newbie problems

I am just trying to get how does it work the color wizard.

I have built a simple table with just one column then I have built a chart with one expression sum(data1)

So far ... it's just a simple chart. No problems at all.

Now I would like to use the color wizard in order to have for the highest and lowest values different colors.

I have used the wizard by puting in the expression sum(data1)/sum(total data1) .

Obviusly it doesn't work.

I would be pleased if somebody can help me with an example about that. Just for understanding how it works.

Thanks in advance for any kind of help

1 Solution

Accepted Solutions
Not applicable
Author

After few tries I got it ....

Thanks for the help Matt ...

All the best !

Ad maiora!

View solution in original post

3 Replies
matt_crowther
Luminary Alumni
Luminary Alumni

I've used the rank() function in the past to sort this one:

=if(rank(sum([Order Count]))=1,rgb(198,255,198),if(rank(sum(total [Order Count])-sum([Order Count]))=1,rgb(255,198,198)))

Where 'Sum([Order Count])' is the expression in my table. Simply place the expression in the Background Colour expression box (click the '+' next to the expresion).

You can alter the rgb() values to change the colour scheme as required.

Alt' Best,

Matt - Visual Analytics Ltd

Not applicable
Author

Thank you very much Matt.... It works perfectly.

Just I was wondering how to use the color wizard to obtain the same result.

If somebody can send me an example it will be great.

Thanks again ...

Not applicable
Author

After few tries I got it ....

Thanks for the help Matt ...

All the best !

Ad maiora!

View solution in original post