multiple if statements

[samuel_brierley]

Hi, I have a table with multiple speeds and I want to format them depending on that speed.

what id like the formula to say is;

if speed is between 20-24 then colour white,

if speed is between 25-29 then colour slightly less white,

Id like to repeat this until about 100 where it should be black.

I can do this in excel but its not quite as easy in qlikview.

thanks

[#2]

Maybe you should try Chart Properties > Visual Cues > Upper and Lower settings.

Hope it works.

[samuel_brierley]

I cant see a tab called visual queues? im using a grid chart if that makes a difference

[#4]

Visual Cues, not Visual Queues. But only exists for Pivot Table and Straight Table.

[samuel_brierley]

apologies Ive found it now its for pivot and straight tables only, but thanks anyway