topic multiple if statements in QlikView

multiple if statements

samuel_brierley — Mon, 09 Dec 2013 12:34:05 GMT

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

Mon, 09 Dec 2013 12:45:34 GMT

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

Hope it works.

samuel_brierley — Mon, 09 Dec 2013 13:06:31 GMT

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

Mon, 09 Dec 2013 13:09:11 GMT

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

samuel_brierley — Mon, 09 Dec 2013 13:09:32 GMT

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