SET A DYNAMIC DATE IN EXPRESSION , CHANGING IT FROM BOX

[valerio347]

Good morning everyone,

I write because I would like to know if my request is feasable:

I have an expression to calculate a lead time between a FIELD and a DATE for  a dimension called Promotion codes:

Count(distinct{$<[CODICE OP]={"=Networkdays([FIELD_A],{'12/03/2019'})>1"}>}[CODICE OP])

My need is to make that date change dynamically and to do not change it everytime in the expression.

Is there a way to create a box inside the sheet where I write the date and the expression change the old date with the new one?

Thank you for your collaboration,

Regards

Valerio 

[Antoine]

Good Morning Valerio,

As far as I know, it's not possible to put input boxes on QlikSense.

However, it might not be the best solution, but I would :

1. create a data Island with a calendar in it (just loading a calendar, not linked to any other field),
2. put it in a filter box on your page (meaning you could select the date from this filter box)
3. Create a variable that would look like this : ='''&GetFieldSelections([Calendar of the Data Island],'","')&'''
4. insert variable in your formula Count(distinct{$<[CODICE OP]={"=Networkdays([FIELD_A],{$(=Createdvariable)})>1"}>}[CODICE OP])