Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Color Expression for row, but if i select the certain dimension

Hi Folks,

i have a situation, i have a pivot table, that has 4 Dimension (for instanse Dim 1, Dim 2, Dim 3, Dim 4) and one Expression.

i created such expression: if(Sum({<Dim = {'Dim2'}>} Sales) > 0.95, rgb(219,219,219)) and it does work, but if i change the order of dimension via drap and drop whitin my pivot,the color expression is still showing.

My Issue, if i select only my Dim2 then the color expression for row should appear, but if i select another Dim, then my colorexpression should disappear.

Does anybody have any idea?

Thanks a lot for your help and feedback

Beck

1 Reply
jmvilaplanap
Valued Contributor

Re: Color Expression for row, but if i select the certain dimension

Hi

I think is because when you click, you're filtering the info.

What happens if you put 1 to your Set Analysis expression?

if(Sum({1<Dim = {'Dim2'}>} Sales) > 0.95, rgb(219,219,219))


Probably now will be different the rule for colouring the cells