Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

isciberras
Contributor

Creating a button with set analysis

Hi can anyone help me please

I am trying to create a button with (ActionsSelect 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

1 Solution

Accepted Solutions

Re: Creating a button with set analysis

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

View solution in original post

4 Replies

Re: Creating a button with set analysis

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

1

isciberras
Contributor

Re: Creating a button with set analysis

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

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

View solution in original post

isciberras
Contributor

Re: Creating a button with set analysis

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