# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Contributor

## Date range using YearQuarter

Hi,

I need to make a range using yearquarter like this:

2016-Q1  - 2016-Q2 if the users selects this way, other than that if they selects 2016-Q1 they will see the current selections and previous period 2015-Q1 numbers.

But when they selects the range as mentioned above like  this  2016-Q1   -  2016-Q2 , the numbers of this will show the current range selections and the previous period range numbers for 2015-Q1  -  2015-Q2.

Data:

Customer, QuarterYear, Sales
BD, 20151, 250
BD, 20152, 370
BD, 20153, 160
BD, 20154, 135
BD, 20161, 466
BD, 20162, 390
BD, 20163, 570
CD, 20151, 210
CD, 20152, 323
CD, 20153, 145
CD, 20154, 136
CD, 20161, 467
CD, 20162, 343
CD, 20163, 568

Thanks,

BootCam

Labels (2)

• ### YearQuarter

1 Solution

Accepted Solutions
MVP

## Re: Date range using YearQuarter

Make your selection in AsOfQuarterYear instead of QuarterYear unless you have a reason to select QuarterYear? If there is, change the expressions to this

```Sum({<Flag={'CY'}, QuarterYear, AsOfQuarterYear = p(QuarterYear)>}Sales)
Sum({<Flag={'PY'}, QuarterYear, AsOfQuarterYear = p(QuarterYear)>}Sales)```
12 Replies
MVP

## Re: Date range using YearQuarter

Where are you looking to do this? In the script or front end?

And the requirement is that if the user select 2016-Q1 - 2016-Q2 , they see 2016-Q1 - 2016-Q2 and 2015-Q1 - 2015-Q2?
Contributor

## Re: Date range using YearQuarter

Thanks Sunny!

I am trying to do it in the front end.

Best,

BootCam

MVP

## Re: Date range using YearQuarter

And what exactly are you hoping to see? Can you explain it step by step?
Contributor

## Re: Date range using YearQuarter

Hi Sunny,

Here it is:

1. I would like to have a QuarterYear list box where the user can select any YearQuarter and in the straight table they will see the value by this selection and also they will see the previous period value as well.

For example, If they select 2016-Q1 they will see the value of 2016-Q1 as the current period value and 2015-Q1 as the previous value.

2. If they select lets say multiple values like 2016-Q1 and 2016-Q2 at the same time they will see this as the current value but for the previous they will see the value for 2015-Q1 and 2015-Q2 value.

I know with this little data its kinda confusing but tried my best to explain.

Best,

BootCam

MVP

## Re: Date range using YearQuarter

I think what you need is The As Of Table

```Table:
Date(MonthStart(Date#(Left(QuarterYear, 4) * 100 + Pick(Right(QuarterYear, 1), 3, 6, 9, 12), 'YYYYMM')), 'YYYYMM') as MonthYear;
Customer, QuarterYear, Sales
BD, 20151, 250
BD, 20152, 370
BD, 20153, 160
BD, 20154, 135
BD, 20161, 466
BD, 20162, 390
BD, 20163, 570
CD, 20151, 210
CD, 20152, 323
CD, 20153, 145
CD, 20154, 136
CD, 20161, 467
CD, 20162, 343
CD, 20163, 568
];

AsOfTable:
Year(MonthYear)*10 + Ceil(Month(MonthYear)/3) as AsOfQuarterYear,
MonthYear,
'CY' as Flag
Resident Table;

Concatenate (AsOfTable)
Year(MonthYear)*10 + Ceil(Month(MonthYear)/3) as AsOfQuarterYear,
'PY' as Flag
Resident Table;```

and then you can use this in your chart

Dimension

`AsOfQuarterYear`

Expressions

```Current Year: Sum({<Flag = {'CY'}>}Sales)
Previous Year: Sum({<Flag = {'PY'}>}Sales)```

Contributor

## Re: Date range using YearQuarter

Hi Sunny,

For some reason, i am getting the wrong numbers after selecting individual YearQuarter  or Range of YearQuarter Selections. Could you suggest?

Best,

BootCam

MVP

## Re: Date range using YearQuarter

Not sure what you mean? What is wrong?
Contributor

## Re: Date range using YearQuarter

Hi Sunny,

Please see the attachment for more elaboration.

Best,

BC

MVP

## Re: Date range using YearQuarter

Make your selection in AsOfQuarterYear instead of QuarterYear unless you have a reason to select QuarterYear? If there is, change the expressions to this

```Sum({<Flag={'CY'}, QuarterYear, AsOfQuarterYear = p(QuarterYear)>}Sales)
Sum({<Flag={'PY'}, QuarterYear, AsOfQuarterYear = p(QuarterYear)>}Sales)```