topic Re: Button Selection not working in QlikView

Button Selection not working

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

Hi All,

I have a issues regarding creating a button which when clicked only shows data where a field is greater than another field.

like:

field 1 is startdate

field 2 is enddate

And would like to create action in Button Select in Field where field is startdate and Search String is > enddate.

This is not working is it not possible to use fields in the Search String?

Or am I doing something wrong.

Thanks in advance.

Ruud.

Re: Button Selection not working

rupamjyotidas — Wed, 14 Jun 2017 16:48:39 GMT

='>=' & enddate

Re: Button Selection not working

Anonymous — Thu, 15 Jun 2017 06:45:28 GMT

Hi Rupam,

Thanks for the quick reply. I have tried your solution but somehow it does nothing when I click the button.

Re: Button Selection not working

Anil_Babu_Samineni — Thu, 15 Jun 2017 06:49:12 GMT

Hello, Would you able to provide sample application

And, Here how Qlikview understand whether which date will consider from enddate.

Re: Button Selection not working

Sergey_Shuklin — Thu, 15 Jun 2017 07:21:30 GMT

Hello, Ruud!

Available solutions:

1. If you don't want to make changes in the script so you'll have to get somehow a string which will contain recent dates divided by "|". For instance "(01.02.2017|01.04.2017|01.05.2017)" and so on - this is the line of dates that satisfy the condition "startdate > enddate".

You can try to use this string as condition: ='('&Concat(if(startdate>enddate,startdate),'|')&')'

2. If you able to edit the script then you can easily add a support column (mark) which will follow the condition "startdate > enddate" and set 1/0 if it's true or false. After that you can create a simple condition in your button like "Search in mark field value equal 1".

Re: Button Selection not working

Anonymous — Thu, 15 Jun 2017 07:45:41 GMT

Hi Sergey,

Ok, that makes sense in SQL I would prefer way 2, and I have tried and works perfectly.

Thanks for the great but easy solution and tip.

Regards Ruud