topic Higher Level value is behaving Odd in QlikView

Higher Level value is behaving Odd

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

Hi All,

I have a Table to show Current Month Actual Sales, Current Month Planned Sales, Current Year Actual Sales and Current Year Planned Sales in Item Level. My issue is in Current Year Planned Sales.

If we check for One particular Item. Item Level data is not Matching. Now If we add Month in dimension. Month wise value is coming correct and summation of all 12 month is also coming correct. But when I remove the Month. It is messing up.

As per my data Current year= 2017 and Current Month = 6.

I am attaching the qvw file.

Please check and help.

Thanks,

Sarif

Re: Higher Level value is behaving Odd

tresB — Fri, 10 Mar 2017 10:20:51 GMT

Try removing DISTINCT keyword from the expression.

Re: Higher Level value is behaving Odd

mhmmd_srf — Fri, 10 Mar 2017 10:24:43 GMT

No wworking sir...

Re: Higher Level value is behaving Odd

tresB — Fri, 10 Mar 2017 10:28:14 GMT

I am getting it like:

using exp: =sum({<CurrentFiscalYearFlag = {1}>} SalesPlanned)

Isn't this your desired output?

Re: Higher Level value is behaving Odd

mhmmd_srf — Fri, 10 Mar 2017 10:40:31 GMT

Tresesco Sir,

We need this Distinct. Else individual data is also not matching with DB. As here we have Two fact table (Actual and Plan in different granularity).

Using distinct above is matching with DB. Only we need to Remove CstFiscalPeriod but it should show 89409.01 for Item no 024091.

Please help.

Thanks,

Sarif

Re: Higher Level value is behaving Odd

tresB — Fri, 10 Mar 2017 10:46:28 GMT

What if you use:

=Sum(Aggr(sum({<CurrentFiscalYearFlag = {1}>} DISTINCT SalesPlanned), CstFiscalPeriod))