topic Re: HELP!!! in QlikView

HELP!!!

Tue, 23 Jul 2013 10:49:26 GMT

Pls find attached. In my example, '-ABC', 'DEF' and 'Others' form 100%. I want to calculate the share of each respective item in Apr 13 and Apr 12 after selecting Apr13. However, I was not able to get the them to add up to 100% for Apr 12. Apr 13 works fine though.

Is there anything wrong with my formula for Apr12?

Sum( {$<Month_Id={"<= $(=Max(Month_Id))"},Month=, Month_Year = >} unit

Aggr(NODISTINCT Sum( {<Month_Id={"= $(=Max(Month_Id)-12)"}, Year=, Month=, Month_Year = >} unit),Year))

For Apr 13, I used the following formula and it works fine:

Sum( {$<Month_Id={"<= $(=Max(Month_Id))"},Month=, Month_Year = >} unit

Aggr(NODISTINCT Sum( {<Month_Id={"= $(=Max(Month_Id))"}, Year=, Month=, Month_Year = >} unit),Year))

Re: HELP!!!

n1ef5ng1 — Wed, 24 Jul 2013 01:41:38 GMT

where are you

Re: HELP!!!

Anonymous — Thu, 25 Jul 2013 06:56:40 GMT

What data is present in your Month_id?

Re: HELP!!!

Thu, 25 Jul 2013 08:54:03 GMT

Its the unique id for the month

Re: HELP!!!

Thu, 25 Jul 2013 14:55:18 GMT

In the first part of your expression for Apr 12, shouldnt it be

Sum( {$<Month_Id={"<= $(=Max(Month_Id)-12)"},Month=, Month_Year = >} unit

Re: HELP!!!

Anonymous — Thu, 25 Jul 2013 15:10:57 GMT

Hello,

try you

Sum(unit) / Sum(Total <Period> unit)