Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
izzatazfar8
New Contributor III

Change bar colour based on the conditional measures

Capture.PNG

Hi, I'm trying to colour the measure using epression

Exp: if(sum([crudedaily]) > Sum([crudeplan]), Sum([crudedaily])='green',Sum([crudeplan])= red())
But the colour not come out, is it my expresion wrong?
What I want is if the sum of crude daily > sum of crude plan , the bar colour is green , else, red.

Tags (1)
8 Replies
Partner
Partner

Re: Change bar colour based on the conditional measures

Expression should be,

if(sum([crudedaily]) > Sum([crudeplan]), green(),red())

Partner
Partner

Re: Change bar colour based on the conditional measures

Also please share sample app to test

izzatazfar8
New Contributor III

Re: Change bar colour based on the conditional measures

This expression didn't work out, Capture.PNG


What I want is the measure for crude daily is green, and crude plan is red

izzatazfar8
New Contributor III

Re: Change bar colour based on the conditional measures

how to insert qvf file?

Partner
Partner

Re: Change bar colour based on the conditional measures

Partner
Partner

Re: Change bar colour based on the conditional measures

Share this sample file if possible to test some expressions

izzatazfar8
New Contributor III

Re: Change bar colour based on the conditional measures

izzatazfar8
New Contributor III

Re: Change bar colour based on the conditional measures

Hi i have sent the file