topic Re: How to Reload the data from 2 to 10 Years in QlikView

How to Reload the data from 2 to 10 Years

Thu, 04 Oct 2012 21:59:48 GMT

Hi Community memers,

I have problem in reloading data.The end user should be given the ability to decide how much data should be loading during data refresh.

example: 2 or 3 years of data should be asked to the user

Re: How to Reload the data from 2 to 10 Years

Thu, 04 Oct 2012 22:07:56 GMT

Hi rameskmcs

Do you wnat select the reload period from web access AJAX / IEPlugign (Acces Point) or Desktop / Server reload?

Re: How to Reload the data from 2 to 10 Years

Thu, 04 Oct 2012 22:26:28 GMT

Hi Marcos,

Thanks for your response, Actually I have 10 years of data, when the user reloads, it should ask for how many years of data you want to reload.

Regards,

rams

Re: How to Reload the data from 2 to 10 Years

Fri, 05 Oct 2012 13:27:41 GMT

Qlikview never ask

Its not Possible.

but could b hard code like if you want ten years data .

Re: How to Reload the data from 2 to 10 Years

jagan — Fri, 05 Oct 2012 14:34:09 GMT

Hi Ramesh,

Try this script

LET vValue = Input('Enter value', 'Input box');

Load

FROM Table

WHERE Year >= Year(Today(), $(vValue));

Hope this helps you.

Regards,

Jagan.

Re: How to Reload the data from 2 to 10 Years

Fri, 05 Oct 2012 17:41:05 GMT

Hi Jagan,

Thanks for your resones, but I am getting below error.can you please tell me where the problem is.My table name

is Treat and my Year field name is Years.I have given the input value as 3 and got the following error

"Cannot open file 'E:\Qlikview\QV V10 Certification Project\Documentation\Treat

where Years>=Year' The filename, directory name, or volume label syntax is incorrect.

LOAD

From Treat

where Years>=Year(Today(),3) "

Re: How to Reload the data from 2 to 10 Years

Gysbert_Wassenaar — Fri, 05 Oct 2012 17:53:28 GMT

You need to change the 'From Table' line. That's just an example. Replace it with a reference to the file or an sql statement to get the data as appropriate to your situation

Re: How to Reload the data from 2 to 10 Years

Fri, 05 Oct 2012 18:30:04 GMT

hi Waseenar I am getting below error can you please correct me

Error in expression:

Year takes 1 parameter

LOAD

from [..\QVd's\Treat.qvd]

(qvd)

Where Years>=Year(Today(),1999)

Re: How to Reload the data from 2 to 10 Years

MayilVahanan — Fri, 05 Oct 2012 22:07:45 GMT

Test:

Load *,Year(Col3) As Year Inline

[

Col1,Col2,Col3,Sales

RO_0001,S1,4/15/2010,100

RO_0001,S2,3/19/2012,200

RO_0001,S2,1/10/2011,300

RO_0002,S2,3/25/2010,400

RO_0002,S2,8/8/2012,500

RO_0002,S1,10/10/2019,600

RO_0003,S1,12/12/2009,700

RO_0003,S2,10/01/2012,800

RO_0003,S2,06/05/2011,900

RO_0003,S2,05/05/2009,1000

] Where Col2='S2';

LET vValue = Input('Enter value', 'Input box');

NoConcatenate

Load Year as Years,Col1 resident Test where Year = Year(AddYears(today(),-$(vValue)));

Hope it helps

Re: How to Reload the data from 2 to 10 Years

jagan — Sat, 06 Oct 2012 14:34:59 GMT

Hi Ramesh,

Hope attached file helps you. It works for me.

Regards,

Jagan.

Re: How to Reload the data from 2 to 10 Years

Tue, 09 Oct 2012 21:01:05 GMT

Thanks ramasamy, thanks for your response.I will try it

Re: How to Reload the data from 2 to 10 Years

Tue, 30 Oct 2012 17:44:11 GMT

Hi Jagan

Thanks for the help. But i dont want to restrict the data initially. I want the full data set from database. Once the data is available in dashboard the user can choose the date range and then filter the full data set for the selected range.

Thanks

Ramesh

Re: How to Reload the data from 2 to 10 Years

jagan — Wed, 31 Oct 2012 13:42:06 GMT

Hi Ramesh,

If user select 2 or 10 years then qlikview automatically calculates for the selected years. Can you explain what you require with an example.

Regards,

Jagan.

Re: How to Reload the data from 2 to 10 Years

Wed, 31 Oct 2012 18:16:35 GMT

Jagan

Thanks for the response

What i am looking for is the following.

1. Using ODBC connection i am fetching the data from Oracle Database.

2. The fetched data is historical data

3. I want to create a dashboard where there user can choose the date range to filter the data ( like input to get start date and end date from dashboard ).

4. Based on this input the data should be refreshed in the dashboard.

Also if you are sending me an example can you send me the script related to it. Reason is that i am using personal edition which has some restriction.

Thanks

Ramesh

Re: How to Reload the data from 2 to 10 Years

jagan — Thu, 01 Nov 2012 10:27:26 GMT

Hi Ramesh,

PFA file, hope it helps you.

Regards,

jagan.

Re: How to Reload the data from 2 to 10 Years

Thu, 01 Nov 2012 17:09:54 GMT

Thanks Jagan

This is what i wanted. But instead of graph i need the data to displayed for the selected period in a container.

For example

When i choose 1/1/2010 - 1/1/2011 it should display only 2 rows in the container.

If you think differently other than container please do let me know.

Steps what i did

1. Created a Container.

2. Added 3 fields into the container. Since Container does not have conditional expression so i added the expression in 3 individual fields.

After adding this i am not able to retrieve only that data range which is given in the inpuit

Thanks

Ramesh

Re: How to Reload the data from 2 to 10 Years

jagan — Fri, 02 Nov 2012 09:47:39 GMT

Hi,

Instead of adding fields in the container you add a chart(straight table) to a container. You do not have any expressions for Container, you can just include Filter or charts in the container. PFA hopt it helps you.

Regards,

Jagan.

Re: How to Reload the data from 2 to 10 Years

Mon, 05 Nov 2012 06:16:44 GMT

Jagan

Thanks again for your help.

I am attaching my example. In this I have the input as start_date, end_date and batch_name. Using these 3 i should display the data for the inputted field.

From your example I found we need an aggregate function on field. Let me know how I can filter the data.

Thanks

Ramesh

Re: How to Reload the data from 2 to 10 Years

jagan — Mon, 05 Nov 2012 09:17:29 GMT

Hi Ramesh,

Your DataModel do not have a field called VIEWCOUNT, that's why you are getting no data in chart. Replace VIEWCOUNT field with appropriate field. PFA.

Regards,

Jagan.

Re: How to Reload the data from 2 to 10 Years

Mon, 05 Nov 2012 18:00:13 GMT

Thanks Jagan

It works. Appreciate your help.

Ramesh