Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

color a cell

What is the correct expression to color a cell yellow?

This is what I have


if(Count(if(Qty=6, RxNo))>28, Yellow())


But I need to expand it out like this


((Sum(if(Qty=6, Lables)))+(Sum(if(Qty=36, Lables))))-(Count(if(Qty=36, RxNo)))+(Count(if(Qty=66, RxNo)))+(Count(if(Qty=96, RxNo)))+(Count(if(Qty=126, RxNo)))


1 Reply

Re: color a cell

May be this

If(Sum({<Qty = {6, 36}>} Lables) - Count({<Qty = {36, 66, 96, 126}>} RxNo) > 28, Yellow())

Community Browser