topic Re: Count If in QlikView

Count If

Mon, 10 Oct 2011 14:07:23 GMT

Hi all,

I'm a newbi at QlikView...i'mdealing with an expression and there is no way to let it works.

I have 3 dimensions:

- [Codice Esito]: a check list (ok/ko)

- [NUM ATT]: is the activity ID

- [Pod Cod Authority DL] is the category

I need the expresison to create a graph to highlight the total activities split by category and the total of activity OK/KO on the total.

I need a count if but I'm not able to manage it on QV 9.

Thanks in advance to all fo you!

Bruno

Count If

its_anandrjs — Mon, 10 Oct 2011 14:16:11 GMT

Hi,

As i understand from your requirement

You have to do calculation like Sum( Total If( [Codice Esito] = 'OK/KO', [NUM ATT] )

Rgds

Anand

Re: Count If

swuehl — Mon, 10 Oct 2011 14:50:54 GMT

Hi Bruno,

I am not really sure what you are after, I assume your checklist somekind of flag with values OK or KO?

>I need the expresison to create a graph to highlight the total activities split by category and the total of activity OK/KO on the total.

I think you need a dimension category [Pod Cod Authority DL] in your chart and then maybe another dimension [Codice Esito] or two expressions with an if().

Or do you want to see different things in your bars / values for each dimension value and for the total?

Please see attached. Maybe you could give an example of what you expect by uploading a file or just adding some data in a post (upload is available in advanced editor on the upper right of the editor window).

Regards,

Stefan