Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Text Box to Show Date Range

Hello,

I have a Date Range I would like to show in a text box that updates when new data comes in and the dashboard is refreshed. I currently have a field called 'Date' and I would like to show in the text box the date range the other dashboard elements are displaying.

For example, I have a Gauge showing a % change Week over Week for the number of Incidents submitted. I would like two text boxes showing:

1. Current Week Date Range

2. Prior Week Date Range

1 Solution

Accepted Solutions
MVP
MVP

Re: Text Box to Show Date Range

Maybe something like

=Weekstart(Today()) & ' - ' &Weekend(Today())

resp.

=Weekstart(Today(), -1) & ' - ' &Weekend(Today(), -1 )

1 Reply
MVP
MVP

Re: Text Box to Show Date Range

Maybe something like

=Weekstart(Today()) & ' - ' &Weekend(Today())

resp.

=Weekstart(Today(), -1) & ' - ' &Weekend(Today(), -1 )

Community Browser