Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am creating a stacked line chart with three colors corresponding to three possible outputs from a column in my data. However when I issue IF statements in the expression I get grey colors and not the colors that I want. I would greatly appreciate if someone could advise me on what I am doing incorrectly. I also get an error that says that the IF statement takes 2-3 parameters.
=if([Curent week status]) = 'R', red(),
else if([Curent week status]) = 'Y', yellow(),
else if([Curent week status]) ='G', green())))
your if statement syntax seems wrong
=if([Curent week status]) = 'R', red(),
if([Curent week status]) = 'Y', yellow(),
if([Curent week status]) ='G', green())))
Hello and thank you for the correction. Unfortunately that format still does not display any color change, everything is still grey.
Please post sample app to look at
I apologize but I'm not sure what you are requesting, I'm still new to this forum. I do not have time to anonymize my data at the moment. Can I share a link to my work privately?
I am asking if you can provide sample qlik sense application to look at?