topic Re: Input Data from Calendar and using the same get the data from the SQL tables in QlikView

topic Re: Input Data from Calendar and using the same get the data from the SQL tables in QlikView https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459880#M171636 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:40:20 GMT 2012-10-26T21:40:20Z Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459873#M171629 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 26 Oct 2012 20:53:26 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459873#M171629 2012-10-26T20:53:26Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459874#M171630 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Please see the attached file.</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 26 Oct 2012 21:08:45 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459874#M171630 MayilVahanan 2012-10-26T21:08:45Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459875#M171631 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:20:30 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459875#M171631 2012-10-26T21:20:30Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459876#M171632 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:21:09 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459876#M171632 2012-10-26T21:21:09Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459877#M171633 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:39:09 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459877#M171633 2012-10-26T21:39:09Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459878#M171634 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:39:26 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459878#M171634 2012-10-26T21:39:26Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459879#M171635 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:40:08 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459879#M171635 2012-10-26T21:40:08Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459880#M171636 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this</P><P></P><P>where date between <startdate> and <enddate></P><P></P><P>If you can provide me with the steps of doing this it will be of great help.</P></BODY></HTML> Fri, 26 Oct 2012 21:40:20 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459880#M171636 2012-10-26T21:40:20Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459881#M171637 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Try like this</P><P></P><P>Where vStart and vEnd are input fields.</P><P>In chart, apply this expression</P><P></P><P>=Sum({<StartDate = {'>=$(=Date(vStart))'}, EndDate = {'<=$(=Date(vEnd))'}>}Sales)</P><P>,</P><P>I hope that startdate n enddate have link..</P><P></P><P>If you need to check the format for input field means, please use like  in the demo application..</P><P></P><P><STRONG>Expression explanation:</STRONG></P><P>So, from these, </P><P></P><P>it calculates the sales, for StartDate is greater than the vStart variable, and EndDate is lesser than the vEnd..If you need restriction means, you can apply like the demo application..</P><P></P><P>In demo application,if you give the invalid format means,its show the error message, that is apply in custom error message in constraints tab.</P><P></P><P>In that tab, we can able to apply the various option.. So from that, we can apply the condition as per our requirement. In number tab, we can change the format, how to apply..</P></BODY></HTML> Fri, 26 Oct 2012 21:47:28 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459881#M171637 MayilVahanan 2012-10-26T21:47:28Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459882#M171638 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Let me try and will update you.</P></BODY></HTML> Fri, 26 Oct 2012 22:44:56 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459882#M171638 2012-10-26T22:44:56Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459883#M171639 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is there any Building Application Guide for the beginners to go over with examples.  </P><P></P><P>Thanks</P></BODY></HTML> Fri, 26 Oct 2012 22:49:29 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459883#M171639 2012-10-26T22:49:29Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459884#M171640 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> 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.</P></BODY></HTML> Fri, 26 Oct 2012 22:59:16 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459884#M171640 MayilVahanan 2012-10-26T22:59:16Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459885#M171641 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>I will wait for your response on monday</P></BODY></HTML> Fri, 26 Oct 2012 23:19:13 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459885#M171641 2012-10-26T23:19:13Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459886#M171642 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Please check the attached file.. May be it helps for you</P></BODY></HTML> Mon, 29 Oct 2012 15:28:02 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459886#M171642 MayilVahanan 2012-10-29T15:28:02Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459887#M171643 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>Let me go throug this.</P></BODY></HTML> Mon, 29 Oct 2012 16:07:41 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459887#M171643 2012-10-29T16:07:41Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459888#M171644 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>What i am trying to do is </P><P></P><P>1. I am connecting to Oracle Database and fetching data from 3 tables.</P><P>2. One of the table is a transaction table.</P><P>3. I want to have 2 input fields ( start and end date ) with a calaneder linked to this input.</P><P>4. Using this input fields i need to refresh the data.</P><P></P><P>So what i am expecting is i need a result displayed based on input.</P><P></P><P>Thanks</P><P></P><P>Ramesh</P></BODY></HTML> Mon, 29 Oct 2012 16:11:33 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459888#M171644 2012-10-29T16:11:33Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459889#M171645 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think there is a confusion in what i expecting. </P><P></P><P>I have a data set for example</P><P></P><P>1,$1000,10/01/2012</P><P>2,$1000,10/02/2012</P><P>3,$500,10/03/2012</P><P>4,$600,10/04/2012</P><P></P><P>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.</P><P></P><P>Hope this explains.  Let me know is there anyway I can do this.</P><P></P><P>Thanks</P><P></P><P>Ramesh</P></BODY></HTML> Tue, 30 Oct 2012 18:21:04 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459889#M171645 2012-10-30T18:21:04Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459890#M171646 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Please find the attached file..</P></BODY></HTML> Tue, 30 Oct 2012 18:39:49 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459890#M171646 MayilVahanan 2012-10-30T18:39:49Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459891#M171647 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am not able to open the file.  It is giving me that the no of recoveries has exceeded in qlikview.</P><P></P><P>Thanks</P><P></P><P>Ramesh</P></BODY></HTML> Tue, 30 Oct 2012 19:00:13 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459891#M171647 2012-10-30T19:00:13Z Re: Input Data from Calendar and using the same get the data from the SQL tables https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459892#M171648 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Exp:</P><P>=Sum({<Date = {'>=$(=Date(vStart))<=$(=Date(vEnd))'}>}Sales)</P><P></P><P>Dim:</P><P>Date</P><P></P><P>Where vStart and vEnd are input fields variable</P><P></P><P>Edit:</P><P></P><P>Please see the attached image, for reference</P></BODY></HTML> Tue, 30 Oct 2012 19:07:04 GMT https://community.qlik.com/t5/QlikView/Input-Data-from-Calendar-and-using-the-same-get-the-data-from/m-p/459892#M171648 MayilVahanan 2012-10-30T19:07:04Z