topic Re: Question on AGGR dimension total in QlikView

Question on AGGR dimension total

Wed, 24 Jul 2013 18:59:22 GMT

Hi All,

I have a simple but complex requirement.

In teh table below I have "# In group" is a calculated dimension based on Group and sub group.

Is there any way I could add a total at "Group level" and Total level?

Thought of converting it to expression, in that scenario it repeats for every year. (is there any way to make an expression independent?)

Thanks in advance,

Aji Paul.

Re: Question on AGGR dimension total

Anonymous — Wed, 24 Jul 2013 20:38:18 GMT

Send the expression that you use.

Re: Question on AGGR dimension total

Wed, 24 Jul 2013 21:58:36 GMT

Andrea,

Please see the qvw attached.

Thanks,

Aji Paul.

Re: Question on AGGR dimension total

Anonymous — Thu, 25 Jul 2013 13:32:41 GMT

I don't see a solution for "total calculated dimension". Maybe there is no any...

If the number of years is always two (or not large in any case), it makes sense to eliminate Year as dimension, and create all caolumns as expressions:
- # In Group
- Qty 2012

- Amt 2012

...

- Total Qty

- Total Amt

Regards,

Michael

Re: Question on AGGR dimension total

Thu, 25 Jul 2013 16:21:46 GMT

Thanks Michael ,

Thought about that but this is a dashboard report which expands by year.

ex. next year we will have 2014 data

Last option is to update the reprot every year 🙂

Thanks,

Aji Paul

Re: Question on AGGR dimension total

Anonymous — Thu, 25 Jul 2013 16:28:57 GMT

Updating application every year is not uncommon - but you don't need to update it for THAT reason. You can define first the max number of years, e.g. five, and create 10 expression based on current year - and make them show conditionally to hide 2011, 2010, etc.

That is, instead 2013, use variable CurrentYear, instead 2012 - CurrentYear-1 (or PrevYear), and so on.

Regards,

Michael

Re: Question on AGGR dimension total

Thu, 25 Jul 2013 21:27:51 GMT

Thanks Michael!

I agree and thats my last option. I do the same with some of my charts and those been working great for couple of years. In those scenario there is only one fact ($Amount) or #Transaction

Here I have (not the uploaded qvw , but the real app) many facts

such as

Qty,

Amt

Total Response

%Response.

Total sent

and few more

the challenge here is to group them by year . If I go by multi expression menthod I might have use the custom format and darken the column aftre the last fact for every year 🙂

Thanks,

Aji.

Re: Question on AGGR dimension total

Anonymous — Thu, 25 Jul 2013 22:01:27 GMT

Question has to be a dimension or can be an expression.

Something like:

=sum(aggr(sum(NumInGroup),Group, [Sub Group], Year))

Re: Question on AGGR dimension total

Thu, 25 Jul 2013 22:04:24 GMT

Andrea,

Thanks for the reply!

Would you please upload the qvw?

Thanks,

Aji Paul

Re: Question on AGGR dimension total

Anonymous — Thu, 25 Jul 2013 22:10:32 GMT

here it is.

Re: Question on AGGR dimension total

Thu, 25 Jul 2013 22:18:58 GMT

Andrea,

Thanks for the qvw..

BTW that is not I am looking for.

I do not want the #in Group to be repeated under year dimension.

Thanks,

Aji.