Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
AJ
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.
Thank you Gysbert, I will try this and post the results. Appreciate the quick turn-around.
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
Hi Tamara,
Once I actually got the data into a single table, this worked great! Thank you!
April