Need help with setting values using a button

[dtate1959]

Hi, I want to be able to create a button that when selected would set the values in a dimension.

My dimensions for selections are  :

State	Phase
Active	Initiation
Concept	Build
On Hold	Deliver
Cancelled	Close Out

Now, I need to be able to have a button that will set the values condition as :

'State' = Concept select all values in 'Phase' ,

also if 'State'   = Active then select Initiation. These selection then apply to a field 'ProjectName'. 

The result would be all ProjectNames that fit either of the conditions.

Using the following if statement as an expression directly in the 'ProjectName' dimension field :

if(([Project Phase] <> 'Initiation' and [Project State] = 'Active') or ([Project State] = 'Concept'),ProjectName,Null())

produces a good list.  But I need to be able to set these values using a button as there is not a good method I see to use a bookmark.

Thanks in advance!!

[sunny_talwar]

So, you are basically looking for a way to select the ProjectName which meet the above two criteria?

[dtate1959]

That is correct!  Obviously , I can't make those selections using filters to satisfy both conditions at the same time. So, was thinking an expression of variable activated by a Button might be the path to follow.

[sunny_talwar]

Try with this search string

='(' & Concat(DISTINCT {<[Project Phase] -= {'Initiation'}, [Project State] = {'Active'}>+<[Project State] = {'Concept'}>} '"' & ProjectName & '"', '|') & ')'

[dtate1959]

Forgive my ignorance, not sure where this would go. I tried using the Search Your Data function and there where no matches.

[sunny_talwar]

Button action of select in field?

[dtate1959]

I'm using the Sheet Navigation & Actions Extension. I've Selected None in the Navigation Action and in the Actions section selected Select Value in a Field used ProjectName as the field name and The pasted your code into the Value field.

Getting no response at all.

[sunny_talwar]

Sorry, I didn't realize that this was Qlik Sense. I am not sure how the extension works, may be someone more knowledgeable might be able to help you better.

Best,

Sunny