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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
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.