Qlik Community

Qlik Sense App Development

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

Not applicable

Colour code by expreesion

Hi all ,

does the following code is correct? not working actually

if(Status='Sanctioned But Not Disbursed',$(Blue),

if((Today-Date1)>=0 and (Today-Date1)<=1,$(Pink),

if((Today-Date1)>=2 and (Today-Date1)<=3,$(Yellow),

if((Today-Date1)>=4 and (Today-Date1)<=5,$(Green),

if((Today-Date1)>=6 and (Today-Date1)<=14,$(Blue),

if((Today-Date1)>=15 and (Today-Date1)<=30,$(Blue),

if((Today-Date1)>=31,$(Beige))))))))

Any Advice

Regards

Charlie

21 Replies
shraddha_g
Honored Contributor III

Re: Colour code by expreesion

if(Status='Sanctioned But Not Disbursed',Blue(),

if((Today()-Date1)>=0 and (Today()-Date1)<=1,RGB for Pink,

if((Today()-Date1)>=2 and (Today()-Date1)<=3,Yellow(),

if((Today()-Date1)>=4 and (Today()-Date1)<=5,Green(),

if((Today()-Date1)>=6 and (Today()-Date1)<=14,Blue(),

if((Today()-Date1)>=15 and (Today()-Date1)<=30,Blue(),

if((Today()-Date1)>=31,Rgb For Beige )))))))

paridhimantri
Contributor

Re: Colour code by expreesion

Hi,

I think (today -Date1 ) is not evaluating firstly you check ,it gives you required output or not,

Please share the more detail on this, So I will help you more on this.

Thanks

Paridhi

sitrakiniaina_j
Contributor II

Re: Colour code by expreesion

Same topic ? Color code expression

dsharmaqv
Contributor III

Re: Colour code by expreesion

post your app pls

Not applicable

Re: Colour code by expreesion

its not working Shraddha

Regards

charlie

shraddha_g
Honored Contributor III

Re: Colour code by expreesion

Share sample data if possible

Not applicable

Re: Colour code by expreesion

find the App and change the colour code by expression.

Not applicable

Re: Colour code by expreesion

i did  chared the app , please check it out the colour code shraddha.

Regards

Charlie

Not applicable

Re: Colour code by expreesion

Same expression working for dimension, but not for colour code .... and one more in the app, measure number formatting , there is a extension variable in the app , for amount  and Count , client want to see the amount in Cr format, count as default , any advice , PFA the app, and the extension  also sharaddha

Help is Appreciated

Thanks in Advance

Charlie

Community Browser