Input Box with Straight Table

[azmeerrehan]

I have created 2 input boxes for Date ranges ,used 2 variable vMinDate and vMaxDate. Now how can I tie that to the straight table. I am using the below expression in the straight table.

Sum({<date = {"$(='>=' & $(vMinDate) & '<=' & $(vMaxDate))"}>} Sales)

Can someone pls let me know what am I missing here ?

[petter]

You should be able to simplify the expression to this:

Sum( { <date={">=$(vMinDate)<=$(vMaxDate)"}>} Sales)

If the field date is a proper date-field with dual values so all the values has both a format and the date-serial number AND both the variables also are dual valued then the above expression should work. 

It will also work if the field date is a pure number and the vMinDate and vMaxDate are pure numbers too - without any date formatting applied.

Be aware that both Max() and Min() strips off any date formatting so the Date() function has to be used to reapply any formatting if you want to keep formatting in the variables.

[azmeerrehan]

Thanx also how can I use the Input Box in Qlik Sense

[petter]

If you run or upgrade to the latest release of Qlik Sense which is November 2018 an input variable extension is included as a part of the extension pack that comes with the software. You can find description of it here: Qlik online Help on Input Variable.

For earlier releases you can download the qsVariable extension and install it manually from Github: 
https://github.com/erikwett/qsVariable

The Github version is the same extension has been included into the latest Qlik Sense by the way - written by Erik Wetterberg... 

[petter]

If you find my replies helpful please click like on any or all of them as it is the only way we get any credit on this new Community site.

[jyothish8807]

Hi,

You can try this extension as well.

https://developer.qlik.com/garden/56728f52d1e497241ae697f8