Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

coloring the cell with the first occurrence value

Hello got a pivot table

I have an expression that displays a ratio shown in percent

I want to color the first cell that has the value >=50%

how can I attain this?

Please advise

I can walk on water when it freezes
Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

With something like =If( ExpressionValue >= 0.5 and above(ExpressionValue) <0.5, color(1) )


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

With something like =If( ExpressionValue >= 0.5 and above(ExpressionValue) <0.5, color(1) )


talk is cheap, supply exceeds demand