Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
So, you are basically looking for a way to select the ProjectName which meet the above two criteria?
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.
Try with this search string
='(' & Concat(DISTINCT {<[Project Phase] -= {'Initiation'}, [Project State] = {'Active'}>+<[Project State] = {'Concept'}>} '"' & ProjectName & '"', '|') & ')'
Forgive my ignorance, not sure where this would go. I tried using the Search Your Data function and there where no matches.
Button action of select in field?
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.
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