topic Re: Last 3 months in Set analysis in QlikView

Last 3 months in Set analysis

chaitanyajami — Wed, 05 Apr 2017 11:14:42 GMT

Hi all, I have 4 Years data in my data model, My req is :

Line chart: Dimensions as : Month Year, Quarter Year, Week Start, Year, Fiscal Year in cyclic group

Expression: Count({<[Month Year]={">=$(vmindate) <=$(vmaxdate)"}>}Distinct(ID)) but iam not getting correct results with the selections

of Year(2014,2015,2016,2017) and CalendarMonthName(Jan,Feb… to Dec)

vmindate=Num(Addmonths(Max([Month Year]),-2)

vmaxdate=Num(Addmonths(Max([Month Year]))

Chart Like: Selection Year=2016, Calndar MonthName= April then it should display feb ,march,april in that year , please suggest how to achieve this

Re: Last 3 months in Set analysis

sunny_talwar — Wed, 05 Apr 2017 11:20:52 GMT

Is your field called Month Year or month Year? Why are there no square brackets around your field Month Year? Would you be able to share a sample to look at your issue?

Re: Last 3 months in Set analysis

chaitanyajami — Thu, 06 Apr 2017 04:09:10 GMT

Hi,

its [Month Year], i wrote the spelling as it is for fields in expression. ok will share