topic Re: Input Box with Straight Table in QlikView

Input Box with Straight Table

azmeerrehan — Fri, 16 Nov 2018 03:17:55 GMT

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 ?

Re: Input Box with Straight Table

petter — Fri, 16 Nov 2018 03:57:36 GMT

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.

Re: Input Box with Straight Table

azmeerrehan — Fri, 16 Nov 2018 05:11:03 GMT

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

Re: Input Box with Straight Table

petter — Fri, 16 Nov 2018 06:30:48 GMT

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...

Re: Input Box with Straight Table

petter — Fri, 16 Nov 2018 06:32:33 GMT

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.

Re: Input Box with Straight Table

jyothish8807 — Fri, 16 Nov 2018 06:52:28 GMT

Hi,

You can try this extension as well.

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