topic Re: Last Records in QlikView

Last Records

Anonymous — Thu, 06 Sep 2018 16:35:24 GMT

Hi All

I am needing help with the following

I want to display the last 4

Etc

So if I select A6 I see A3, A4, A5, A6

If I am at A50 I see A47, A48, A49, A50 etc

In script

Any ideas how to achieve this?

vamsee — Thu, 06 Sep 2018 19:03:46 GMT

Try

AddMonths(Floor(MonthEnd(Today())),-12)

AddMonths(Floor(MonthEnd(Max(Date_Field))),-12)

and then achieve Quarters from that date

Anonymous — Thu, 06 Sep 2018 19:25:34 GMT

I Don't Know What exactly you mean here

Lets make it simple

I have records

When I get to 5 I want to show 2, 3, 4,5

When I am at 40 I want 36,37,38,39

Whatever record I am showing I want to show only the last 4 records, I hope this makes sense

Thanks

sergio0592 — Thu, 06 Sep 2018 19:32:14 GMT

You can just make :

Floor(MonthEnd(Today(),-12))

Floor(MonthEnd(Max(Date_Field),-12))

vamsee — Fri, 07 Sep 2018 13:53:26 GMT

I didn't quite understand your example, as previously you said you wanted to see last 4 Quarters.

Anyway, can you provide a sample of your data and the chart where you want to see this?