topic Help with IntervalMatch in QlikView

Help with IntervalMatch

Mon, 24 May 2010 23:00:05 GMT

Hey all, I'm hoping someone can lend a hand. I'm new(ish) to QV, and am trying to set up a date range selection based on the following post by John Witherspoon.

http://community.qlik.com/forums/t/17316.aspx

I downloaded the testDateGrouping2.qvw sample and copied the code from the 'Range Table' tab into my own app, and updated it to use the shipping date column (Ship_Date) that's being loaded in a previous tab:

JOIN (Ranges) IntervalMatch (Ship_Date) LOAD RangeStart, RangeEnd RESIDENT Ranges;

After I reload the data, I can see the Range table with the correct options. ('Today', 'Yesterday', 'This Week', etc.) However, it isn't linked to the actual Ship_Date column from my source table. (I can select a range, but it doesn't restrict the ship dates in my data.)

Am I correct in assuming that I should be able to link the 'Range' selection to any date column by simply updating the argument to IntervalMatch?

I've searched the forums and manuals, and just can't seem to get this to work. I'm sure it's something simple I'm overlooking, but it's eluding me.

Thanks in advance for any help, I do appreciate it!

~Mark

Help with IntervalMatch

johnw — Tue, 25 May 2010 01:39:41 GMT

It's actually Rob Wunderlich's code. I just modified it based on a specific request.

Yes, I believe you should be able to link the Range selection to any date column by simply updating the argument in the intervalmatch. So yes, it's probably something simple, but I don't really have a guess as to what it might be. If you could post a sample application with the problem, I could debug that, but we already have a working sample application, so I'm not sure how much that would help.

Help with IntervalMatch

Wed, 26 May 2010 19:05:01 GMT

John, thanks for your quick response. (And to Rob for the original code.)

I noticed that the 'Ranges' table doesn't contain the date I'm trying to join on in the IntervalMatch. (It's an 'orphaned' table when I open the table viewer.) That leads me to believe there's an issue with the join.

I tried aliasing the date to see if it's an issue with the format:

date(Ship_Date) AS Range_Date

but I still can't get it to join.

Unfortunately, HIPAA regulations prevent from posting my app without significant modification. (I may have to create one that I can post if I can't figure this out.)

Thanks again,

~Mark

Help with IntervalMatch

Thu, 27 May 2010 16:55:48 GMT

Rookie mistake! With the IntervalMatch code in place, I was unable to refresh the app. (Memory errors.) I was trying to do a Partial Reload, which wasn't enough of a reload to do the join to the Ranges table. (It was enough to create the Ranges table, however.) Once I was able to get on the server and do a complete reload, everything worked as expected.

Hopefully this lesson will prove useful for others, and save some frustration.

Nice functionality Rob!

Thanks,

~Mark