Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check the extension qsVariable http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8
It has option for select in dropdown option with predefined values
Check the extension qsVariable http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8
It has option for select in dropdown option with predefined values
There is not that future with sense. But why can't you create separate field and use that as filter?
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.