Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Quater creation

How to create a quater with out using 'Q' &ceil (month(date)/3) and  inline function ?

8 Replies
Not applicable

Re: Quater creation

check this out, it could help you.

greetings!!

Not applicable

Re: Quater creation

brother i am dealing with personal edition , so can i have same code on the wall

Not applicable

Re: Quater creation

Usually, we load a table with the quarter and the month number with the statement INLINE

LOAD * INLINE [

month, quarter

1,1

2,1

3,1

4,2

5,2

6,2

7,3

8,3

9,3

10,4

11,4

12,4];

Not applicable

Re: Quater creation

ok, I get that but, if you load an inline statement like the above example, you will get the field quarter automaticlly, you don´t need to creat a new quarter becouse you have it already. or try to post your script to check it out.

Not applicable

Re: Quater creation

in the attached application: you can do quartername(Date) as quarter. I prefer the inline solution: less loading time.

Not applicable

Re: Quater creation

I thanks for your hospitality, It help me find the other aspect of the coding

Highlighted
Not applicable

Re: Quater creation

Thank you very much , I worked on it and working out. EvaPolini i am trying to figure out via some sort of string or mapping procedure other than inline and

Not applicable

Re: Quater creation

Dear Friends, Iwould thanks for the support to figure out the way in creating quater.

I love to share the way of creating quater via mapping concept.

Month_des:

Mapping Load * Inline
[
Map_id,MAp_status
1,Q1
2,Q1
3,Q1
4,Q2
5,Q2
6,Q2
7,Q3
8,Q3
9,Q3
10,Q4
11,Q4
12,Q4
]
;


Directory;
Sales:
LOAD [Transaction ID],
Year,
Month,
ApplyMap('Month_des',Month) as Month_desc,
Day,
[Salesman ID],
[Product ID],
[Serial No],
[ID Customer],
[List Price],
Sales,
[Gross Margin]
FROM
[Tutorial\Application\Data Sources\TRANSACT.CSV]
(
txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Community Browser