topic Re: Group values by period in QlikView

Group values by period

claudio_reis_we — Sat, 20 Feb 2016 13:55:10 GMT

Hello,

Could you help me please?

I am using a simple table chart and I need to add the value of two or more periods. My main question is how to make the sum of the results to display in a single period.

Example. Jan/2015 = 10, Feb/2015 = 20

This illustrates:

Period Value

Jan/2015 30

Thank you,

Re: Group values by period

Anonymous — Sat, 20 Feb 2016 16:39:18 GMT

If you have a Master Calendar you could create a new dimension for [2 Month Period] with something like this :

MonthName ( makedate ( Year ( [YourCalendarDate] ) , ( 2 * ceil ( Num (Month( [YourCalendarDate]) / 2 ) ) ) -1 ) )

Re: Group values by period

Gysbert_Wassenaar — Sat, 20 Feb 2016 16:41:19 GMT

Perhaps like this: sum(TOTAL Value)

Re: Group values by period

MarcoWedel — Sun, 21 Feb 2016 23:05:32 GMT

Hi,

one solution using a calculated dimension:

hope this helps

regards

Marco

Re: Group values by period

claudio_reis_we — Wed, 24 Feb 2016 01:14:24 GMT

Hello Marco,

His statement works partially, maybe I have not used properly. I'm sending a picture to who can view and see if it fits in this situation.

Each year will have the sum of the quantity of the last 12 months. In this example 2016 is the amount this year + amount of 10 months of 2015.

Thank you.

Re: Group values by period

MarcoWedel — Sun, 28 Feb 2016 22:37:56 GMT

please post a sample application and your expected result

regards

Marco