Table Box filters records by selecting date range ... - Qlik Community

Report Inappropriate Content · ‎2014-02-18

Hello All,

I am workin on a scenario where I have to show my full table,no counts or sum.So I am using simple table box for it.Now I have to put two calender objects(one for selecting start date and other for end date) and by selecting these two dates I have to filter out records in table box.I am done with table box and calender objects.But filteration is not working on selecting dates.Can anyone help me regarding this.The date field in the table was in datetime format,I have convert in into date in qlikview using floor and date function.

Thanks in advance and looking forward for quick reply.

Hey guys,here is the test file.I have added two calender objects and table box ,but data is not filtered on basis of selections of these dates.Please provide me solution for this.I can use straight table chart in place for table box but requirement of showing is just the contents of table ,so no dimensions can be specified.

Message was edited by: Tushar Sharma

whiteline · ‎2014-02-18

Hi.

Could you post a sample ?

Or describe how the calendar objects are connected with the data model (fields/variables).

Do you have start date and end date as fields in your data model ?

Colin-Albert · ‎2014-02-18

Use a single list box with a search expression to get the dates between a start and end value rather than two separate list boxes. Enter >01/02/14<17/02/14 as the search expression to select dates from Feb 1st 2014 to Feb 17 2014, if your dates are DD/MM/YYYY format.

Also a table box may not be the best object to use to show your data unless you include a unique ID for each row of data in the table box. A table box object shows each unique row for the selected fields not all rows.

maxgro · ‎2014-02-18

here you can find a qvw about selecting date range with two calendar

The Basics about Dates, Date Ranges and Set Analysis

aveeeeeee7en · ‎2014-02-18

Hi Tushar

See the Attached.

Reference:Creating Multiple Search Using a Button

Report Inappropriate Content · ‎2014-02-19

Actually,I cant post as it is office work.I create two calender objects.Now for max and min values,I set max and min values of my date field of table for setting max and min values of calender objects.I am not able to connect the data model with calender objects.Data model doesnt have any start date and end date .Data model has one date field,whose max and min values,I need to use as min and max values of my calender objects.

For sample,we can take a table which has two columns(one is unique id and other is ApproveDate.).Now we just need to show this table in qlikview(I am using table box for it,not sure if I am using correct object) and we need to provide a date filter(to choose one start date and other is end date) so that on selecting a date range only those records displayed in the table box which falls in selected range.For creating calender, I want to use datamodel's date column(approvedate).

Report Inappropriate Content · ‎2014-02-19

I think,Single list box is not a good option to select two dates.Aslo for the end user,it is not good to enter some expession like this to filter on date.I think,providing two calender objects for selecting start and end date is good option ,also easy to use for the end user.So need to implement this.

My table contains a unique id column,and what object I can use to show simple a table.I didnt want to show any count or sum.Just want to simply show content of my table.

whiteline · ‎2014-02-19

You have to connect the list boxes to your table.

If you created two variables for start/end you can create a chart instead of the table box and use these variables to show only values between them.

This approach works but it's a step aside from the QV associative logic.

Another way is to create the button that allows to make the corresponding selection in the date field.

More complex approach is to create two triggers for variables to perform the selection each time the values are changed. But it can frustrate the user when he selects the date field directly.

Colin-Albert · ‎2014-02-19

This example shows how you can select a range of dates

http://community.qlik.com/docs/DOC-5598

maxgro · ‎2014-02-19

see attachment, I modified your .qwv:

the tablebox is filtered by 2 calendars objects, ecc,ecc,....

the approach is one of the approach suggested by whiteline

".....More complex approach is to create two triggers for variables to perform the selection each time the values are changed......"

but

I fully agree with whiteline, if possible, use qlikview native associative logic

Table Box filters records by selecting date range from two calender objects