topic Re: Date Formats in QlikView

Date Formats

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I am trying to calculate the Max(Month) along with last 6months trend with the below expression

=Sum({<Area= {'America'},MonthYear={">=$(=date(addmonths(Max(MonthYear),-6),'MMM-YY')) <=$(=date(Max(MonthYear),'MMM-YY'))"}>}Incidents)

Here I ma getting the last 6motnhs but not getting the max(month) in the bar chart. I am missed anything.Please help me.

For example in the below getting Mar to Aug but I need the max(Month) i.e. sep-17 also.

Thanks.

Re: Date Formats

Miguel_Angel_Baeyens — Wed, 13 Sep 2017 11:09:57 GMT

Assuming MonthYear has a numeric value (i.e.: a date) are there incidents for that month? Because the syntax looks fine for me.

Re: Date Formats

Kushal_Chawda — Wed, 13 Sep 2017 11:14:11 GMT

Make sure that for Area= {'America'} you have incidents in Sep 2017, if there are no incidents for this region it will show 0 value

Re: Date Formats

bhavvibudagam — Wed, 13 Sep 2017 11:26:39 GMT

Hi Kushal,

I have the data on Sep-17 in the source need to get 100.0% their remaining all the months getting correctly. Only max(month) not getting in the trend.

Re: Date Formats

Kushal_Chawda — Wed, 13 Sep 2017 11:29:38 GMT

Would you be able to share the sample? without looking at sample it will tough to say what is the issue. Expression looks fine to me