Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please help urgent....!!!!

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.

For example:

Amit is having:

Yellow      Red

3                3

Please help me to get this result in qlikview.

5 Replies
Not applicable
Author

Hi,

You can use the same expression to take a count of the cells, which is used for colour coding.

Regards,

Neha

Not applicable
Author

Hi Neha,

Im new to qlikview.

Plz can you share exact expression for Column color.

Thanks,

Prabhu ch

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert...........

er_mohit
Master II
Master II

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......