Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

mounth count

hi,

how can i count the mounth name ?

i need it to fomule for Average.

thanks'

yarin.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

If you have month field in MMM YYYY format then you just calculate

=Count(DISTINCT MonthDimension)

Regards,

Jagan.

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

If you have month field in MMM YYYY format then you just calculate

=Count(DISTINCT MonthDimension)

Regards,

Jagan.

Anonymous
Not applicable
Author

hi,

the formet field is only the name of the mounth,(januar, febr...)

i try to use your formule but i get nothing.

do you have any idea ?

thanks' for your help.

yarin.

Anonymous
Not applicable
Author

hi,

the formet field is only the name of the mounth,(januar, febr...)

i try to use your formule but i get nothing.

do you have any idea ?

thanks' for your help.

yarin.

Anonymous
Not applicable
Author

hi,

sory it's working good.

yarin.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you close this discussion by clicking "Correct Answer" button to my post.  So that it helps others to find answer.

Regards,

Jagan.