Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
vsharma1
Partner
Partner

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
dilipranjith
Partner
Partner

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

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

dilipranjith
Partner
Partner

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
Partner
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
Partner
Author

I am also preparing sample data and model for you 

vsharma1
Partner
Partner
Author

 
vsharma1
Partner
Partner
Author

attaching model screenshot

vsharma1
Partner
Partner
Author

attaching chart

rwunderlich