Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
KellyK
Contributor
Contributor

Pivot Table - limit data to only TODAY's date and forward - Expressions include a Count & a URL

I am trying to limit the data pulled into a pivot table to only data with a date greater than today.  The first Expression  below works by itself.

Expression 1)

=count({<[Visit Start Date]={">=$(=Today())"}>}1)

When I add the URL expression to the Pivot Table -it also brings in data prior to today - based on the date selection on the page, but I only want data in this table >=Today.

Expression 2)

=if([Visit Start Date]>=$(=Today()),'Link to Form <url>'&FormURL,0)

Thank you for any help you can offer.

@sunny_talwar

Labels (2)
2 Solutions

Accepted Solutions
sunny_talwar

May be this is what you are looking for

=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)

View solution in original post

pradosh_thakur
Master II
Master II

what about 

 

concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)

Learning never stops.

View solution in original post

2 Replies
sunny_talwar

May be this is what you are looking for

=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)
pradosh_thakur
Master II
Master II

what about 

 

concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)

Learning never stops.