calculate No fo Months in Year

[vsharma1]

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 

[dplr-rn]

share a sample of the data and a screenshot of what the output looks like

[vsharma1]

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

[dplr-rn]

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]

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]

I am also preparing sample data and model for you 

[vsharma1]

attaching model screenshot

[vsharma1]

attaching chart

[rwunderlich]

count(TOTAL<Year> YearMonth)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com