Custom Color in Measure Without Value List

[scotly-victor]

Hi Eveyone,

                   I have one dimension and three measures , I wanted give color based on measure value ,I know by using value list we can achieve it .However my requirement is without using valuelist  I wanted to give color to my three measure

[ishanbhatt]

Hi Patric,

Thanks a lot. I'll check it and if this run then it'll solve 70% design issues.

[ishanbhatt]

Hi Scotly,

Download and update Qliksense Desktop 3.1 t0 3.2 and follow the patric answer.

Ishan

[priyasawant]

Hi... First create an inline for sales.

Then select both the dimensions and create measure

pick(Match([Sales Type],'CYSales','PYSales','FYSales'),sum(CYSales),sum(PYSales),sum(FYSales))

and mention the same in Appearance --> colors and legend --> Color By Expression --> and write your required color

Pick(Match([Sales Type],'CYSales','PYSales','FYSales'),Red(),Green(),Yellow())

For further clarification please find the attached QVF...