topic Re: Tell me below requirement? in QlikView

Tell me below requirement?

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to provide input box to the user.

If user enter any date in the input box and automatically select in month in month list box or chart.

Ex: user enter 10/06/2017 in input box it automatically select Jun month in other month list box. How to achieve this?

Re: Tell me below requirement?

Anil_Babu_Samineni — Fri, 18 Aug 2017 13:59:47 GMT

For this, you can achieve like. Please handle one variable called as Variable1

Then, In list box, you can call it as expression to =If(DateField = Variable1, MonthField)

If it is in straight table, You could state that variable as Sum({<DateField = {"<= Variable1"}>}Sales) // Here, You can manipulate if date format issue

Re: Tell me below requirement?

vishsaggi — Fri, 18 Aug 2017 14:13:28 GMT

One way is you can use triggers to select the Month field with the date entered in the Inputbox.

Create a variable using Inputbox. Then using your monthfield add a trigger from Doc Properties ctrl+atl+D then variable event triggers select the variable created from inputbox.