Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Contributor II

Open sheet should select always latest 5 Quarters ?

Hi,

When i Open a sheet always latest 5 Quarters should be selected in my Qlikview Report , how can we do it?

my Quarter field is FY_QYM

in that values is as per below

Quarter.PNG

Best Regards,

14 Replies
Highlighted
Honored Contributor II

Re: Open sheet should select always latest 5 Quarters ?

You will have to apply a numeric value (straight numbering or a date-value) to the string denominating the quarter.

Subject to this you will have to create a trigger on document open to select the topmost 5 values.

See a simple example in the attached file - think that you will catch the point.

Highlighted

Re: Open sheet should select always latest 5 Quarters ?

Check if that helps

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor III

Re: Open sheet should select always latest 5 Quarters ?

HI,

I tried but it's not working as expected. i am ttaching my app in original Request. can you try it there.

Highlighted
New Contributor III

Re: Open sheet should select always latest 5 Quarters ?

!

Highlighted

Re: Open sheet should select always latest 5 Quarters ?

Before open yours, Have you attempted mine?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor III

Re: Open sheet should select always latest 5 Quarters ?

Hi Anil,

Yes i tried yours as well. but not able to.

one more point is when you do rank always it should take latest 5 quarters means Q4FY17, Q1FY18, Q2FY18, Q3FY18 and Q4FY18.

Highlighted
Honored Contributor II

Re: Open sheet should select always latest 5 Quarters ?

I can't see your app?

Highlighted
New Contributor III

Re: Open sheet should select always latest 5 Quarters ?

HI  Peter,

It says Default Test below. That's my app.

New Contributor III

Re: Open sheet should select always latest 5 Quarters ?

Hi Peter,

I have created a Rolling 5 Quarters variable in my attached app. but when i try to pass it to sheet open trigger it is not taking it.