topic Re: How should i script to automatically create four quarter for every Year ? in QlikView

How should i script to automatically create four quarter for every Year ?

alina_qlik — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts ,

I have Year field , i want to create four quarters for each year . Being a new qliker I do not know , how to do it .

Please help .

INPUT

LOAD * INLINE [
YEAR
2015
2016
2017
2018
2019

];

OUTPUT

kaushiknsolanki — Wed, 17 Jul 2019 09:26:28 GMT

Hi, Use the cross join to do that. Like shown below.

Data:

LOAD * INLINE [

YEAR

2015

2016

2017

2018

2019

];

Join (Data)
Load * inline [

Qtr

];

Regards,

Kaushik Solanki

alina_qlik — Wed, 17 Jul 2019 09:34:07 GMT

Thank You kaushik . Is there any other way without using join , i mean something like looping four times .

kaushiknsolanki — Wed, 17 Jul 2019 09:42:59 GMT

Hi,

You can but this would be the easiest option I can think of. If you want to try for loop you can do that too.

Multiple for loop will be required.

Regards,

Kaushik Solanki

Brett_Bleess — Mon, 12 Aug 2019 15:20:40 GMT

Just wanted to toss out a Design Blog post that might work as well:

Regards,
Brett