Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Count problem...

1.JPG.jpg

hi!

i've got this table and i want to build a graphic that shows how many people were born in each year of the column "ANNO_NASCITA".

When i try to build a graphic i used function COUNT, but the graphic shows me each year of the table... for example i've two slice for the year 1945 !! So what kind of function i've to use to solve this problem??

Tags (1)
4 Replies
bbi_mba_76
Valued Contributor

Re: Count problem...

Hi,

what do you count? how is your expression?

Re: Count problem...

Usa come dimensione l'anno di nascita e come espressione:

count(Matricola), dovrebbe funzionare.

Fammi sapere

Ciao

anbu1984
Honored Contributor III

Re: Count problem...

Can you show your app?

ferha_jafri
Contributor II

Re: Count problem...

Do you want to count the people born in a particular year , if that is the case then you must have the names in some column ,

so try this in dimention you will take year in x-axis and expression write : substringcount(Name,Name)

Community Browser