topic Create Button Action Based on Criteria in QlikView

Create Button Action Based on Criteria

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to implement a simple button to make a selection dynamically, but am trying to get my head around the "Select in Field" action.

I have 3 fields: CitizenID, ResidenceTown, WorkTown

I want to make the button to select only CitizenID where ResidenceTown = WorkTown.

Have tried the below but it isn't working.

Any tips would be great!

Re: Create Button Action Based on Criteria

MindaugasBacius — Thu, 17 Nov 2016 06:48:01 GMT

Have you tried making a simple flag in the script:

Load *

,If(ResidenceTown = WorkTown, 1, 0) as CitizenFlag

From Source;

Then in the Action tab Field you you write CitizenFlag and in the Search String 1.

Re: Create Button Action Based on Criteria

Thu, 17 Nov 2016 06:50:41 GMT

My ResidenceTown and WorkTown fields are in different tables, hence I'm unable to use the Flag method

Re: Create Button Action Based on Criteria

lironbaram — Thu, 17 Nov 2016 06:51:02 GMT

you'll need to use an expression that creates a list on customers as an output

so you'll need to use in the search string something like

='(' & concat(aggr(if([WorkTown]=[ResidenceTown],CitizenID),CitizenID),'|') & ')'

Re: Create Button Action Based on Criteria

tamilarasu — Thu, 17 Nov 2016 06:52:21 GMT

Hi Chay,

='(' & Concat(Distinct If([WorkTown] =[ResidenceTown] ,CitizenID),'|') & ')'

Re: Create Button Action Based on Criteria

MindaugasBacius — Thu, 17 Nov 2016 06:53:49 GMT

Also, for more clarification the action Select in Field works like this.

You choose the Field and the Search String you can write the possible values from the Field.

For example in the Field you've written CitizenID. It contains data like (1, 2, 3, 4 and so on). In this case Search String means you have to write down the CitizenID like 4.

Re: Create Button Action Based on Criteria

Thu, 17 Nov 2016 06:56:46 GMT

Thanks Tamil

Works well.

Re: Create Button Action Based on Criteria

tamilarasu — Thu, 17 Nov 2016 07:07:10 GMT

Hi Chay,

I forgot to mention one point. If your CitizenID contains any spaces like "ID 0001" then above method won't work. To be on the safer side, you can write like

='(' & Concat(Distinct If([WorkTown] =[ResidenceTown],Chr(34) & CitizenID & Chr(34)),'|') & ')'

This expression works in both the cases.

Re: Create Button Action Based on Criteria

trdandamudi — Thu, 17 Nov 2016 08:34:22 GMT

One more way of doing this is as follow: Hope this helps.....

='(' & concat( {<CitizenID={"=WorkTown=ResidenceTown"}>} CitizenID, '|') & ')'