How to make straight table only show values with in selected date range?

[#1]

Hi,

I have a straight table in qvw. when user selects date range. the user wants to pull data only with in selected date range. The table is pulling all values including date range selections data and blanks. but the user wants to see only data in the table based on date range selections. how to make the table show only data within the selected date range?

the table have below

Dimension 1: =If(Match(CODE ,'IN','OUT'),ENTRYID)

Dimension 2: Order

Expr1: =Only(Name)

Expr2: =Only(StafdMember)

Expr3: =Max(ConnectionDate)

Expr4:  =FirstSortedValue(BOOKTEXT,-ConnectionDate)

Date selections have below Triggers in OnChange

vStartDate: ='>='&vStartDate & '<=' & vEndDate

vEndDate  : ='>='&vStartDate & '<=' & vEndDate

Please can anyone suggest me.

Thanks.

[buzzy996]

yes u can do,but how users are selecting start date & end date from front end?

[#3]

through input box. can you let me know where I need to use the above mentioned triggers please?

[#4]

Hi Amelia,

You can use something  like

date here will be you date filed in your data.

Expr1: =Only(date={'>$(=$(vStartDate)  <=$(vEndDate)'}>}Name)

Hope it helps

[buzzy996]

"Document Event Triggers"  syntax through Documents properties--trigger tab of ur qvw

[#6]

Thanks. I have used this and the column is showing all blanks.

[#7]

Thanks. where I need to use this?

[#8]

Well u share your Qvw? may be a reduced one so that we can investigate further.

Also do u need a dynamic straight table or a simple one.

[#9]

what to use in value OnOpen for vStartDate

OnOpen

set variable

vStartDate

[buzzy996]

for vStartDate--no need to define anything here

for vEndDate--=Today()

[ramoncova06]

Amelia,

check this post, it contains an example as well

QlikView App: Dates, Date Ranges and Set Analysis