Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thomakel
New Contributor III

Input box with Predefined values


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

Tags (2)
1 Solution

Accepted Solutions
skamath1_metlif
New Contributor III

Re: Input box with Predefined values

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

It has option for select in dropdown option with predefined valuesCapture.PNG

3 Replies
skamath1_metlif
New Contributor III

Re: Input box with Predefined values

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

It has option for select in dropdown option with predefined valuesCapture.PNG

Re: Input box with Predefined values

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

thomakel
New Contributor III

Re: Input box with Predefined values

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.