Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
KellyK
New 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

2 Solutions

Accepted Solutions

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

May be this is what you are looking for

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

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

what about 

 

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

Learning never stops.
2 Replies

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

May be this is what you are looking for

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

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

what about 

 

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

Learning never stops.
Community Browser