topic Months wise value in QlikView

Months wise value

prma7799 — Thu, 25 Feb 2016 05:46:24 GMT

Dear All,

I am getting value on months wise when taking months as dimension but when I am using below expression then its not showing values for max months

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear=$(=max(FiscalYear))}>}[Date]))"}

>}DivT)

Thanks

Re: Months wise value

bohravanraj — Thu, 25 Feb 2016 06:01:04 GMT

let vMonthName = monthname(max(Date)); SUM({$}DivT) Try Above Code

Re: Months wise value

Thu, 25 Feb 2016 06:32:59 GMT

Please Try this Expression.

sum({$<Fiscalyear={$(=max(FiscalYear)},

Date={'>=MonthStart(max(PostingDate))<=MonthEnd(=max(PostingDate)')>}DivT)

Re: Months wise value

PrashantSangle — Thu, 25 Feb 2016 06:41:05 GMT

Hi,

try like

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear=$(=max(FiscalYear))}>}[Posting Date]))"}

>}DivT)

on which date field you want to compare ?? on Date or [Posting Date]???

Regards

Re: Months wise value

PrashantSangle — Thu, 25 Feb 2016 07:41:39 GMT

Hi,

are doing any number formatting in first output.

value looks similar for max month i.e. Feb in first output and in second output.

only difference in number formatting.

Regards,