Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Chewitt
Contributor II
Contributor II
‎2020-02-17 07:54 AM

Error in expression

Hi, 

Can anyone tell me what is wrong with this background colour expression:

if([Data Point 1] = "Variance",
if([Query Name] = "AA",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(0,255,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AB",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AC",
if(Value>0.1,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AD",
if(Value>0.1,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AE",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AF",
if(Value<-0.025,rgb(0,255,0),if(Value<=0,rgb(255,140,0),rgb(255,0,0))),
if([Query Name] = "AG",
if(Value>0.06,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,155,0)))))))))))

Labels (1)
Labels
366 Views
0 Likes
2 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist
‎2020-02-17 08:20 AM

Hi

Try this

if([Data Point 1] = "Variance",
if([Query Name] = "AA",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(0,255,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AB",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AC",
if(Value>0.1,rgb(255,0,0),if(Value>0 and Value<=0.1,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AD",
if(Value>0.1,rgb(255,0,0),if(Value>0 and Value<=0.1,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AE",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AF",
if(Value<-0.025,rgb(0,255,0),if(Value<=0 and Value>=-0.025,rgb(255,140,0),rgb(255,0,0))),
if([Query Name] = "AG",
if(Value>0.06,rgb(255,0,0),if(Value>0 Value<=0.06,rgb(255,140,0),rgb(0,155,0)))))))))))

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
351 Views
0 Likes
NitinK7
Specialist
Specialist
‎2020-02-18 08:13 AM

Hi,

try this

= if([Data Point 1]='Variance',

if([Query Name]='AA',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(0,255,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AB',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(255,0,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AC',
if(Value>0.1,rgb(255,0,0),
if(Value>0,rgb(255,140,0),rgb(0,255,0)))),



if([Query Name]='AD',
if(Value>0.1,rgb(255,0,0),
if(Value>0,rgb(255,140,0),rgb(0,255,0)))),

if([Query Name]='AE',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(255,0,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AF',
if(Value<-0.025,rgb(0,255,0),
if(Value<=0,rgb(255,140,0),rgb(255,0,0)))),


if([Query Name]='AG',
if(Value>0.06,rgb(0,255,0),
if(Value>0,rgb(255,140,0),rgb(255,0,0))))


)



312 Views