Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Rolling Quarter and Completed Quarter

Hi,

Can some one help for below question.

I have Quarter Field and values is like below

Q118, Q218, Q318, Q418, Q119, Q219,Q319

 

But now i want to write in a script to get a new field for Quarter for that what i needs is

 

First point: always it should give latest 5 rolling Quarters , means in this example it should give me

Q318, Q418, Q119, Q219,Q319

but again Q319 is not completed Quarter so i should not get Q319 till Quarter completes.

Quarte completes means

 

i have month filed like values below

(201811, 201812, 201901  ) ----Q119

(201902, 201903, 201904  )----- Q219

(201905, 201906, 201907  )----- Q319

so in my report max month now is 201905 , so till i get 201907 month value in my report i should not see Q319, till that my last five Quarters should be

Q218, Q318, Q418, Q119, Q219 for that i need to write a script and derive a field in load script .

how can we write that.

Best Regards,

HK

 

 

 

 

 

 

 

 

 

 

 

1 Solution

Accepted Solutions
dunnalahk123
Creator III
Creator III
Author

Hi All,

 

Not Required i did at front end by creating Variables.

View solution in original post

1 Reply
dunnalahk123
Creator III
Creator III
Author

Hi All,

 

Not Required i did at front end by creating Variables.

View solution in original post