Qlik Community

Qlik Sense App Development

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

izzatazfar8
New Contributor II

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
shraddha_g
Honored Contributor III

Re: Change bar colour based on the conditional measures

Expression should be,

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

shraddha_g
Honored Contributor III

Re: Change bar colour based on the conditional measures

Also please share sample app to test

izzatazfar8
New Contributor II

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 II

Re: Change bar colour based on the conditional measures

how to insert qvf file?

shraddha_g
Honored Contributor III

Re: Change bar colour based on the conditional measures

shraddha_g
Honored Contributor III

Re: Change bar colour based on the conditional measures

Share this sample file if possible to test some expressions

izzatazfar8
New Contributor II

Re: Change bar colour based on the conditional measures

izzatazfar8
New Contributor II

Re: Change bar colour based on the conditional measures

Hi i have sent the file

Community Browser