topic Re: Creating a button with set analysis in QlikView

Creating a button with set analysis

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

Hi can anyone help me please

I am trying to create a button with (Actions – Select in field).

I want the button to incorporate the following set analysis filter:

[day]={'Mon','Tue','Wed,''Thu','Fri'}, [time]={">06:45:00"} as well as [day]={'Sat','Sun'} without any time filter

Basically what I am trying to achieve is Monday to Friday only bringing back logs greater than the following time: 06:45:00 as well as all logs on sat and Sunday irrelevant of a time filter.

Does anyone know if this is possible?

Thanks,

Isaac

Re: Creating a button with set analysis

sunny_talwar — Fri, 17 Nov 2017 12:44:04 GMT

Why don't you create a flag in the script like this

If(Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45), 1, 0) as Flag

and now use this in your button action

Field

Flag

Search String

Re: Creating a button with set analysis

isciberras — Fri, 17 Nov 2017 13:19:43 GMT

Thank you, that worked great however the part I'm struggling with is including Sat and Sun without any time filter, would you happen to have any ideas?

Re: Creating a button with set analysis

sunny_talwar — Fri, 17 Nov 2017 13:23:32 GMT

May be this

If((Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45)) or Match(day, 'Sun', 'Sat'), 1, 0) as Flag

Re: Creating a button with set analysis

isciberras — Fri, 17 Nov 2017 14:35:16 GMT

You are a genius thank you so much for your help you always sole my problems when I'm completely stuck