Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Vizlib default date

Hi!

I use the Vizlib calendar extension in an app.

I want the app when open to present data for the previous 5 days .

I use the "Initial Selection" and can set a "Initial Start Date".

What should the formula be in order to present the previous 5 days?

25 Replies
groveliam
Creator
Creator

and you can always replace those "max(dateField)" with "Today()"

stekol61
Creator
Creator
Author

Hi!

A little bit complicated but I will try.

Where do I create variables in Sense?

stekol61
Creator
Creator
Author

Hi!

I guess this is the way to do it:

SET d1 = Date(max(Date)-1, 'YYYY-MM-DD');

SET d2 = Date(max(Date)-2, 'YYYY-MM-DD');

LOAD

Week (Date)as Week,

    Country,

    "Answered Calls",

    Date((Date),'YYYY-MM-DD') as Date,

    %CALENDARID

FROM


I then added: $(d1) in the Vizlib filter.

This works OK, but if I add $(d1), $(d2) it dosn't work


Giuseppe_VizLib
Partner - Contributor III
Partner - Contributor III

Hello!  🙂

You may reach us at support@vizlib.com 

or you can open a ticket after you login to our User Portal.

You can also evaluate as a free trial, by downloading and installing our Vizlib June 2019 Release.

regards

Giuseppe

Vizlib Customer Success Manager

Giuseppe_VizLib
Partner - Contributor III
Partner - Contributor III

I was actually taking a look at this, and will let you know ASAP

Giuseppe_VizLib
Partner - Contributor III
Partner - Contributor III

Hello,

there is a functionality under the section called INTERACTIVITY.

The setting is called INITIAL SELECTION

regards

Giuseppe