Discussion board where members can get started with QlikView.
I am having a xlsx sheet which looks like this:
Here with the help of qlikview i want to count number of yellow and Red color cells w.r.t each person horizontaly in all the sheets i.e 1,2 & 3.
Amit is having:
Please help me to get this result in qlikview.
You can use the same expression to take a count of the cells, which is used for colour coding.
Im new to qlikview.
Plz can you share exact expression for Column color.
Qlikview can't read the cell formating from excel. It can only read in the values of the cells, not the color of the cells.
if you wants to change the format or using colour function then in click on expressions icon minimize side on the left ang then you can change the colour.
hope this helpyou......