topic Button 1D not working in QlikView

Button 1D not working

nikhilgarg — Fri, 22 May 2015 11:24:49 GMT

Hello,

I tried to make an application where i am trying to show data as per 1D, MTD and YTD. i ahve make trigger on 1D but it is not working can someone tell mewhy .

Thanks

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 11:31:40 GMT

Couple of changes and it is working now.

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 11:41:13 GMT

‌Those were the only two changes I made (i think). Make those two changes and see if it works.

Re: Button 1D not working

nikhilgarg — Fri, 22 May 2015 11:51:55 GMT

Hey,

Thanks it works but in case of MTD i am stucking somewhere.

For MTD:

i used 2 var:

vDateMin = =MonthStart(max({1}LoginTime))

vDateMAx = =max({1}LoginTime)

In button's action's tab i have used 2 setvariable for these and in SelectInField i have used LoginTime with value:

>= vDateMin and <= vDateMax

Where am i wrong ?

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 11:59:13 GMT

Try this for your select in field: ='>=' & vDateMin & '<=' & vDateMax

Re: Button 1D not working

nikhilgarg — Fri, 22 May 2015 12:48:47 GMT

Hey,

I tried this but still not working. I have attached the file. Please have a look.

Thanks

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 12:51:44 GMT

It is working but you are just not seeing it make the selection because All the LoginTime dates are within the range you have specified here.

Look at the green dot next to the column LoginTime

Before:

After:

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 12:54:29 GMT

Actually found the bug. You need to change the definition for vDateMin to this:

=Date(MonthStart(max({1}LoginTime)), 'YYYY-MM-DD')

HTH

Best,

Sunny

Re: Button 1D not working

nikhilgarg — Fri, 22 May 2015 12:55:28 GMT

Hey,

Actualy it is working but not in correct way. Well the loop was in MTD vDateMin expression:

I used the expression:

=MonthStart(max({1}LoginTime)) which gives date in DD-MM-YYY format while my dates are in 'YYYY-MM-DD' format.

So, i have used:

=date(MonthStart(max({1}LoginTime)), 'YYYY-MM-DD') It is working now.

Thanks

Re: Button 1D not working

nikhilgarg — Fri, 22 May 2015 13:30:10 GMT

Hey sunny,

one more thing. I want to make YTD as default filter for data when user comes to this sheet. So how can i do that ? Althoughj i have added triggers on Sheet. But still it is not working fine. Even when clear is selected, YTD data sld be shown. I ahve attached the file. Pls suggest.

Thanks

Re: Button 1D not working

sunny_talwar — Fri, 22 May 2015 13:39:40 GMT

For clear function, you can try to use the set clear state option:

Select that option after you have selected the YTD information and after that anytime the user will press clear it will default to YTD information only.

HTH

Best,

Sunny

Re: Button 1D not working

nikhilgarg — Fri, 22 May 2015 14:10:05 GMT

I tried but it doesnot work. I select YTD and then (ctrl+shift+D). It just clear all thing . nothing happens.

Thanks