topic Re: Please help urgent....!!!! in QlikView

Please help urgent....!!!!

Wed, 12 Dec 2012 07:04:12 GMT

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.

Re: Please help urgent....!!!!

Wed, 12 Dec 2012 07:33:32 GMT

Hi,

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

Regards,

Neha

Re: Please help urgent....!!!!

Wed, 12 Dec 2012 08:02:43 GMT

Hi Neha,

Im new to qlikview.

Plz can you share exact expression for Column color.

Thanks,

Prabhu ch

Re: Please help urgent....!!!!

Gysbert_Wassenaar — Wed, 12 Dec 2012 13:00:48 GMT

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.

Re: Please help urgent....!!!!

Wed, 12 Dec 2012 13:21:16 GMT

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

Re: Please help urgent....!!!!

er_mohit — Wed, 12 Dec 2012 13:32:10 GMT

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