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

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

julioarriaga — Fri, 08 Sep 2017 23:12:09 GMT

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.

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

Anil_Babu_Samineni — Sat, 09 Sep 2017 03:14:27 GMT

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)))

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

effinty2112 — Sat, 09 Sep 2017 11:21:12 GMT

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

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

rohitraut — Sat, 09 Sep 2017 16:45:17 GMT

Hello Julio,

Try this ,

dimension:

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

Expression:

Sum(Value)

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!