topic count expression with text in QlikView

count expression with text

Fri, 10 Jun 2011 10:41:06 GMT

Hello,

I have a question about the count expression. For example, we have table of driver's (fields ID_driver, name_car, city....), then i have a car's table (fields, id_car, name_car, driver_id, car_type). I would like to make a stack graph with the number of drivers that use a type of car. I mean, in the y axe we will have count(id_driver) and in the x axe (city). The question is how can i do the y axe? if i use count(id_driver) it doesnt work, id_driver is a text, i need to counter the numbers of drivers that we have in each city. If i have not been clear, please let me know.

Thanks

count expression with text

Fri, 10 Jun 2011 11:22:14 GMT

Hi Raul,

What is the result you get with that expression? Too many values than the expected?

Try usind count( DISTINCT id_driver ).

I assume there are numeric and repeated values because it is a key, so you have to use the DISTINCT clause.

If that doesn't help please explain better the tables involved.

Regards.