topic Re: How to select multiple field values with one click in QlikView

How to select multiple field values with one click

Anonymous — Thu, 04 Jan 2018 16:06:29 GMT

Hello all, I could use some help. I'm new to QlikView, and not a developer, just have had some exposer to SQL in the past.

I want a button or other item that does all of this in one click. The idea is the user clicks one button and all of the below are applied as selections.

Field Name: Status

Selection: Red (text string)

And

Field Name: PM

Selection: Name 1 OR Name 2 OR Name 3 (text string, would be real names)

And

Field Name: State

Selection: Work in Progress OR On Hold OR Pending (text string)

And

Field Name: Month Created

Selection: Current Month (match today's date to the month value in another field or to a text field which I created out of a date stamp. Should be based on today’s date, without having to change it each month)

Can this be done? I am not a programmer so I’m trying to do this with simple statements. Such as:

Status =Red

And PM =(Amy Swazey|Beth Doty|Colin Bloor|Aparna Singh)

And State = (Work in Progress|On Hold|Pending)

And Month Created = (month(Today))

I’ve tried adding more than one Select in Field to a button, but it seems to only execute the first item.

Thanks in advance for any help!

Re: How to select multiple field values with one click

Gysbert_Wassenaar — Thu, 04 Jan 2018 17:47:56 GMT

Make the selections manually once. Then create a bookmark to store the selections. Then explain to the users how to use bookmarks in Qlikview. If you really want you can create a button and add an Apply Bookmark action to it that applies the bookmark you created.

Re: How to select multiple field values with one click

Anonymous — Thu, 04 Jan 2018 18:27:07 GMT

Thank you Gysbert, I will try this and post the results. Appreciate the quick turn-around.

Re: How to select multiple field values with one click

t_witzgall — Fri, 05 Jan 2018 07:38:28 GMT

Hi April,

if your values are all in the same table you could create a flag for that.

e.g.

if( Status = 'Red' and

(PM = 'Amy Swazey' or PM = 'Beth Doty' or PM = 'Colin Bloor' or PM = 'Aparna Singh')

and (State = 'Work in Progress' or State = 'On Hold' or State = 'Pending')

and [Month Created] = month(Today()) , 1) as NameYourField

You can now create a button which sets NameYourField = 1

So your month is calculated when the script is executed.

When using a Bookmark keep in mind to change the month manually to the new month at last day of old / first day of new month. The bookmark saves the static value (so e.g. January) and not month(today())!

Regards Tamara

Re: How to select multiple field values with one click

Anonymous — Wed, 10 Jan 2018 17:10:30 GMT

Hi Tamara,

Once I actually got the data into a single table, this worked great! Thank you!

April