Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use expression without limiting selection

Hi all,

Please see code;

Aggr(sum({<Object = {'ZZ0012'}>}Volume),MonthYear)/

Aggr(sum({<Object = {'ZZ0012'},MonthYear={'Mar-2012'}>}Volume),MonthYear)

The second line is meant to be a calculated value, but without restricting selections on months which it does right now. So how can I use MonthYear March 2012 without limiting the selection?

Thanks and regards,

Tom

4 Replies
Not applicable
Author

Let me understand this correctly  - you want the second line NOT to be limited to Mar-2012?

But you want it to start with march-2012 or?

If you remove MonthYear={'Mar-2012'} there is no filter on monthYear

Otherwise you could try using getfieldselection and then trigger the document to start up in march

qlikpahadi07
Specialist
Specialist

Hi Tom,

If I am not wrong then you can split Month year as

Aggr(sum({<Object = {'ZZ0012'},Year = {$(=Max(Year)),  Month= {$(=Max(Month)) >}Volume),MonthYear)

Not applicable
Author

Thomas/Pahad,

Thanks for so quick a response. Unfortunately, It is not what I am after, but I probably should have explained more.

I specifically want the sum of the volume, aggregated per March 2012 as a value, because that is the chosen baseline month. That means I do no want a minimum month.

Say that March has as summed/aggregated volumes of 120 and April 140 and May 180. Then the results in percentages should be:

March: 120/120=100%

April: 140/120=117%

May: 180/120=150%

So using the fixed value of the summed volumes of Month March works just fine as long as you compare the sum of ALL volumes in a month. However, the volumes are categorized and it should be possible to make a selection in it. For ease of calculation say the volumes are spread as follows between category A and B;

March 70/30

April 60/40

May 65/35

With the fixed value, if I make the selection for category A, it would say:

March: (0,7*120)/120=70%

April: (0,6*140)/120=70%

May: (0,65*180)/120=98%

Whereas it should be:

March: (0,7*120)/(0,7*120)=100%

April: (0,6*140)/(0,7*120)=100%

May: (0,65*180)/(0,7*120)=139%

Hope this makes sense

Thanks!

Tom

qlikpahadi07
Specialist
Specialist

I am sorry If i didn't get you properly again. you can attach a simple qvw which will help us to understand.

well I thing you can use Varaible where you can assign the value to varaible and divide it with your expression.

Let Var1 = Aggr(sum({<Object = {'ZZ0012'},MonthYear={'Mar-2012'}>}Volume),MonthYear)


so next time you can use ... exp/Var1


may be helpful