Qlik Community

Qlik Sense App Development

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

simonmccoy
New Contributor

Backround formatting

Hi, I have an app here that I upload a usage limit to every day my expression picks the most recent date but im trying to format the column to show colours around the status of inventory.. so with the code below I get the output I require when I select the most recent date but im looking for the page to open and this formatting to be applied to the most recent date. So im wondering how I could build

{<[Value Date]={"$(=Date(Max([Value Date])))"}>} into the below If statement. If anyone has any ideas it would be great

Thanks

IF([Stock.Status]='FAIL',RGB(255,0,0),

IF([Stock.Status]='PASS',RGB(0,200,0),

IF([Stock.Status]='WARN',RGB(255,255,0))))

Community Browser