topic Re: Date filter issue on button click in QlikView

Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 15:21:29 GMT

Hi All,

I am trying to filter dates on the basis of button click. but dates in the list box are not getting filterd. As I have created 2 variables and i am setting variable level triggers also. Attached the QVW file.

Thanks

Dasu.G

Re: Date filter issue on button click

Tue, 12 Mar 2013 19:09:00 GMT

Your date formats weren't reconciling. See attached.

Re: Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 20:35:37 GMT

Thank you Rebecca,

I got this issue resolved in desktop mode but still issue persists in web view?. Do you have any thoughts to handle this kind of scenario in webview ? .

Steps:

1. Open the attachement provided by you.

2. Clear

3. Click on webview

4. Click on those buttons

5. No change in the business date list box..

Re: Date filter issue on button click

Tue, 12 Mar 2013 20:57:44 GMT

Triggers are funky in WebView. Instead of using the trigger, add the action to your text objects and then double click to filter. It's annoying, but I don't know a better way.

Re: Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 21:26:32 GMT

Your document is working with out any issues in desktop with one click and in webview two clicks. But I tried implement same in my app also it is not respeciting QV associations in desktop and webview. Not retrieving min(c_date) ie MinBusinessDate from seleciton it is giving from complete data set .do you have any thouhts?.

Attached the ligther version of my app.

Re: Date filter issue on button click

Tue, 12 Mar 2013 21:33:56 GMT

Again, your date formats were not the same. Once you remove the NUM() from the expressions, it behaves fine. In your first app, your dates were in the numeric form; in this second file, your dates were in M/D/YYYY form. See attached.

Re: Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 21:41:55 GMT

MinBusinessDate(Min(c_date) still not retrieved from the selected data set. It is always having 10/1/2012 and it supposed to have the start date value

Re: Date filter issue on button click

Tue, 12 Mar 2013 21:51:15 GMT

With the small data set you had, 10/1/2012 would be the min for either selection. Take a look with more data. Note that you need to double click the selections.

Re: Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 22:07:22 GMT

Hi Rebecca,

Some times In single click itself I am able to see the change in both desktop and webvew in my machine. how to interpret this behaviour not sure when it is working and when it is not working?.

Thanks

Dasu.G

Re: Date filter issue on button click

Anonymous — Tue, 12 Mar 2013 23:30:58 GMT

Any one has idea what is the expected behavoir in this case?.

If we are going with double click is there any way we can restrict single click?.

How to support triggers in the webview mode?

Re: Date filter issue on button click

sushil353 — Wed, 13 Mar 2013 04:48:18 GMT

Hi ,

i think the same you have posted in another post as well

http://community.qlik.com/thread/74751?tstart=0

i have commented on this thread. please find the attached and let me know your concern..

HTH

Sushil

Re: Date filter issue on button click

Anonymous — Wed, 13 Mar 2013 10:52:47 GMT

Sushil,

Thanks for the response. My concern is that when we add Select in action on the text box. The bahaviour is not predictable (Rebecca already mentioned the same). It is working some times in single click some times I need to do double click. What ever recbacca/you mentioned I have implemented same in my application i noticed

same behavior only double click it is filtering enitre dataset but in single click it is setting all the external variables.

You can down load attachment from rebacca(4th Reply) Mar 12, 2013 4:57 PM (in response to dasugairaboni) triggers are not working in webview mode need some more details what scenarios triggers are not working and what is the best parctice here. So we removed those triggers and it started working on double click some times( Exactly not able to understand the behaviour).

Thanks

Dasu.G

Re: Date filter issue on button click

sushil353 — Wed, 13 Mar 2013 11:09:50 GMT

Yes, it is behaving weird.

is it mendatory for you to have selection action in textbox or button object.

We can try to solve it using set analysis.

HTH

Sushil

Re: Date filter issue on button click

Anonymous — Wed, 13 Mar 2013 12:28:39 GMT

Do you know how to perform these kind of filters using set analysis?

Re: Date filter issue on button click

trey_bayne — Wed, 03 Apr 2013 17:06:04 GMT

I can't reproduce the problem but I'd venture the guess that the variable $(vAUMGrowthEndDate) is not getting set in time to evaluate in the Set in Field statement.

When in AJAX, the action is setting the variable, converting it to a QlikView action and then evaluating it in the next action step (another conversion is necessary). If there is latency in the network or the converstion process this would cause an inconsistency issue. The first click sets the variable and the second click picks up the variable you set with the first click. Once the variable is set the issue probably goes away.

A simple workaround would be to handle the Select in Field using Set Analysis as suggested by dasugairaboni

='>=$(=DATE(ADDMONTHS(TODAY(),-6))) <= $(=today())'

could go in the Set Field Action and get rid of the Variables.

Re: Date filter issue on button click

Tue, 12 Aug 2014 15:29:36 GMT

Hi Trey,

Have you received any solution for this, I am also in similar situation.

Could please share me, if you find out any solution on this problem.