Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph

I have one straight table in which I have red,green and yellow colors of row.

I want to calculate the count of the no of rows whose color is green and the total no of rows.

and want to calculate Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).

And Want to calculate that expression in to the bar chart with the formula

Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).


3 Replies
settu_periasamy
Master III
Master III

Hi,

how do you get the colors (green,red, yellow)? if it is your expression background color, then you can use same expression for your other calculation.

mightyqlikers
Creator III
Creator III

hi

please post sample data with desired requirement.

PradeepReddy
Specialist II
Specialist II

As Settu suggested, use the color coding expression to get the count..