Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.