topic Re: How do I load only rows user needs today? in QlikView

How do I load only rows user needs today?

Fri, 14 Sep 2012 17:11:21 GMT

How do I load only rows user needs today? I see how to load from a database using ODBC and SQL, but I do not see how to load only the data the user needs. It may take an hour to load a year's worth of data. Can a user set a start date that determines how much is loaded today? I searched the forum but perhaps did not use the proper keywords to find this topic if it already exists.

Re: How do I load only rows user needs today?

Nicole-Smith — Fri, 14 Sep 2012 17:55:16 GMT

LET vStartDate = '2012-09-14'; //This date can be made whatever you want, but the date

//must be in the same format that it is in SQL

Table:

LOAD Field1, Field2;

SQL SELECT

Field1,

Field2

FROM

"YourSQLTable"

WHERE

DateField in ('$(vStartDate)');

Re: How do I load only rows user needs today?

Mon, 08 Oct 2012 21:22:36 GMT

This answer works great for me. I have a follow-on question. I would like to see if there is a way I can offer the user a list of parameters and let them choose the parameters they want to use, then use their parameter list in the query.

Is there something similar to what you did above?

Would the solution involve changing the $(v for variable to $(f for field ?

Thanks,

Tom

Re: How do I load only rows user needs today?

Nicole-Smith — Wed, 10 Oct 2012 15:23:58 GMT

You can offer them a list of parameters in variable form (check out input boxes for this). The query would then be the same as what I have above minus the LET statement. However, you have to remember that when they change what is in the variable, that won't be reflected automatically on the dashboard. A reload needs to happen in order for this to be reflected. If you are hosting the dashboard on a server, I don't think this will work.

Re: How do I load only rows user needs today?

Wed, 10 Oct 2012 15:48:25 GMT

Thanks,

Does this work if they are allowed to select more than one item? I thought a variable was for a single item.

Tom

Re: How do I load only rows user needs today?

Nicole-Smith — Wed, 10 Oct 2012 20:05:30 GMT

You could have two variables (StartDate and EndDate) and do a load where LoadDate >= StartDate AND LoadDate <= EndDate.

*Note that what I have above is not correct syntax.