Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hii

hi all ,

i am hvng data as

quarter

Q1

Q2

Q3

Q4

,year

2009

2010

2011

2012

,month,

jan

.

.

.

.dec

so the result vil b lik dis..

i wan year field as 2009Q1

2009Q2

2009Q3

2009Q4

like so on...upto 2012

means evry year i vil get wit in qurters

Please help me...

10 Replies
arulsettu
Master III
Master III

sorry try like this

Year & Quarter as YearQuarter

Not applicable
Author

you can concatenate your fields like this

Load *,

Year&Quarter as YearQtr;

load * inline [

Year,Quarter,Month

2011,Q1,Feb

2012,Q3,Aug

2009,Q2,Jun

];

Not applicable
Author

Okay Bhavana ..Tanq fr Sugg..i wil try

Not applicable
Author

hI FIND BELOW SCREEN SHORT..

Hvng am hvng 2year data

if i select Q1 of 2010 display 2009 Q4

2010

Q1--->Q2

Q2---->Q3

Q3---->Q4

Q4---->Q1   if Q4 select dispay previous year Q1 Data so Plase Find

Not applicable
Author

Can you please clarify your pbm statement clearly and send me your .qvw file as well.

Thanks

Lathaa

senpradip007
Specialist III
Specialist III

Please clarify your problem properly.

Not applicable
Author

hi,,

In year 2009 four quaters Q1 to Q4

In year 2010 four quatersQ1 to Q4

if i select q1 in 2010 it wil disply 2009 q4 details lik so on...

means if v select q3 v vil disply q2 .....

senpradip007
Specialist III
Specialist III

Its clear that if Q1 of 2010 selected it will display data of Q4 of 2009. Its fine. Now what do you want if Q3 of 2010 is selected? Please clarify.

Not applicable
Author

Hi,

see this qvw.It is correct answer.