Input Data from Calendar and using the same get the data from the SQL tables

[#1]

How do I get the matching data based on the input passed from the Input Fields. For example if have start and end date as my input how do i filter the records from the main data for the inputted values.

[#2]

Hi

Is there any Building Application Guide for the beginners to go over with examples. 

Thanks

[MayilVahanan]

Hi

press f1 in qv application...you can see help book ..and also in qv  reference manual  you can  able to find info about concepts.will upload some other pdf on monday..am in outside..i think some other will give betterguideness.

[#4]

Thanks

I will wait for your response on monday

[MayilVahanan]

HI

Please check the attached file.. May be it helps for you

[#6]

Thanks

Let me go throug this.

[#7]

Hi

What i am trying to do is

1. I am connecting to Oracle Database and fetching data from 3 tables.

2. One of the table is a transaction table.

3. I want to have 2 input fields ( start and end date ) with a calaneder linked to this input.

4. Using this input fields i need to refresh the data.

So what i am expecting is i need a result displayed based on input.

Thanks

Ramesh

[#8]

Hi

I think there is a confusion in what i expecting.

I have a data set for example

1,$1000,10/01/2012

2,$1000,10/02/2012

3,$500,10/03/2012

4,$600,10/04/2012

This is the initial data set which i get from SQL Year.  In the dashboard i have 2 input fields Start Date and End Date.   If i provide 10/01/2012 and 10/02/2012 then it should display only the first 2 records. Even though i get full record set in the SQL i need to filter based on the input provided by user.

Hope this explains.  Let me know is there anyway I can do this.

Thanks

Ramesh

[MayilVahanan]

HI

Please find the attached file..

[#10]

Hi

I am not able to open the file.  It is giving me that the no of recoveries has exceeded in qlikview.

Thanks

Ramesh

[MayilVahanan]

HI

Exp:

=Sum({<Date = {'>=$(=Date(vStart))<=$(=Date(vEnd))'}>}Sales)

Dim:

Date

Where vStart and vEnd are input fields variable

Edit:

Please see the attached image, for reference