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: 
vsharma1
Partner - Creator
Partner - Creator

calculate No fo Months in Year

Hi,

I want to calculate number of months  yearwise based on calendar table
I am doing count(yearmonth) to calculate number of months , yearmonth is column in calendar table

when i am adding other dimension in my chart it is giving wrong value 3 instead of 5 for current year 2019 

17 Replies
dplr-rn
Partner - Master III
Partner - Master III

share a sample of the data and a screenshot of what the output looks like
vsharma1
Partner - Creator
Partner - Creator
Author

sorry I cant share sample data but please let me know if anything is not clear to you

dplr-rn
Partner - Master III
Partner - Master III

Need details to diagnose the problem. adding another dimension to the chart shouldnt effect the total count for the year. so it must be a something in your data or expression or model.
give examples, screenshot, something i can work with.
vsharma1
Partner - Creator
Partner - Creator
Author

There is a dimension Business Segment connected with a link table

 Link table has data for only 3 months for current year for Business Segment value "others", when I am adding Business segment dimension in chart the count of yearmonth  is changing from 5 to 3 for Business segment  "others"

vsharma1
Partner - Creator
Partner - Creator
Author

I am also preparing sample data and model for you 

vsharma1
Partner - Creator
Partner - Creator
Author

 
vsharma1
Partner - Creator
Partner - Creator
Author

attaching model screenshot

vsharma1
Partner - Creator
Partner - Creator
Author

attaching chart

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP