Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

Hi,

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

Regards,

Neha

Not applicable

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

Hi Neha,

Im new to qlikview.

Plz can you share exact expression for Column color.

Thanks,

Prabhu ch

MVP & Luminary
MVP & Luminary

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

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

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

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

er_mohit
Honored Contributor II

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

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

Community Browser