Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.