Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sorry I cant share sample data but please let me know if anything is not clear to you
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"
I am also preparing sample data and model for you
attaching model screenshot
attaching chart
count(TOTAL<Year> YearMonth)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com