Input box with Predefined values

[thomakel]

Hi ALL,

anybody an idea how to do that in QlikSense:

Input box with Predefined values coming from a ... | Qlik Community

We need a inputbox with two variable (vStartdate- and vEnddate) as drop-down with semicolon separated predefined values.
In QlikView this is straightforward with "Input Box" with settings in "Constraints" tab:

At the end we want do calculations base on a certain period (vStartdate and vEnddate) what is selected by the users.
Input box with drop-down list in Qlikview looks like this here:

Our expression will be look like this:
sum({<Salesdate={">=$(vStartdate_FromDate<=$(vEnddate_ToDate)"} >} Sales)

Thx in advance.
Thomas

[skamath1 · Accepted solution]

Check the extension qsVariable http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

It has option for select in dropdown option with predefined values

[Anil_Babu_Samineni]

There is not that future with sense. But why can't you create separate field and use that as filter?

[thomakel]

Hi Shivanand,

thx for pointing out this extension.
Drop-down with date list is working now.

I had to add a new variable with new separator '|'.

LET vdate_dropdown = 'Concat(DISTINCT date, '&chr(39)&'|'&chr(39)&')';

This is different story but unfortunately my expression is not working correctly with:

firstsortedvalue({<date={">=$(vFromDate)<=$(vToDate)"}>} distinct

            aggr(nodistinct sum({<date={">=$(vFromDate)<=$(vToDate)"}>} nr_of_X), date)
, -snapshot_date)

THX again for mention "QS variable" extension.