How do I create a dimension in QV object in which each record groups certain dates?

[julioarriaga]

Hi everyone,

Thank you for your time in answering this question. I want to create an object (not doing it in script) that has a dimension that groups the Date field in certain values (like the Range and SumValue field at the bottom of image 1). How can I accomplish this?

Kind regards.

[Anil_Babu_Samineni]

May be this?

Create Straight Table and use

Dimension

=ValueList('R1','R2')

Expression

If(ValueList('R1','R2')='R1',sum({<Date = {'01/07/2017','02/07/2017'}>}Value),

If(ValueList('R1','R2')='R2',sum({<Date = {'03/07/2017','04/07/2017', '05/07/2017'}>}Value)))

[effinty2112 · Accepted solution]

Hi Julio,

You get this straight table with the calculated dimension Range =

=Aggr(Pick(Match(Date,

'01/07/2017',

'02/07/2017',

'03/07/2017',

'04/07/2017',

'05/07/2017'),

'R1','R1','R2','R2','R2'),Date)

Range	Sum(Value)
	65
R1	24
R2	41

Regards

Andrew

[rohitraut]

Hello Julio,

Try this ,

dimension:

If(Date=makedate(2017,07,01) or Date=makedate(2017,07,02) ,'R1','R2')

Expression:

Sum(Value)

OR

Dimension:

If(Date=makedate(2017,07,01) or Date=makedate(2017,07,02) ,'R1',

     if(Date=makedate(2017,07,03) or Date=makedate(2017,07,04)  or Date=makedate(2017,07,05),'R2'))

Hope this help!