topic Re: Actions - Select in field (search string) in QlikView

Actions - Select in field (search string)

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

In our line of business every completed PBI (problem) should have a related PKE (known error).

Recently Mani and Joshua on this community helped me with an expression for a text box below which shows all the completed PBI's that does not have a PKE linked.

=count(if([PBI_STATUS]='Completed' and len(Replace(PKE_ID,'-',''))=0 ,1))

In this example the total should be 3.

PBI_ID	PBI_STATUS	PKE_ID
5452	Completed	7785
2154	Completed	-
4523	Assigned	2154
9541	Assigned	-
2157	Completed	-
1235	Completed	-
3258	Completed	1546
1464	Draft	5852

This all works perfectly fine but I would like a user to be able to click on the text box and it should reflect the data in a table. So I added actions

Select in field - PBI_STATUS - (Completed) - This works perfectly
Select in field - PKE_ID - Null values - I dont know how to do this

Problem is I do not know how to put this. I want to show all the values that does not have a PKE (Null values). How can I go about this?

Re: Actions - Select in field (search string)

sunny_talwar — Thu, 28 Apr 2016 15:26:27 GMT

I guess select in field action with something like this:

='(' & Concat(DISTINCT {<PBI_STATUS = {'Completed'}, PKE_ID = {'-'}>} PBI_ID, '|') & ')'

Re: Actions - Select in field (search string)

Tue, 03 May 2016 05:14:25 GMT

Hi Sunny,

The search string is OK with no errors but nothin happens when I click on the text box.

I alreaedy have a "Select in field" for PBI_STATUS = Completed so no need to combine all into one string.

All I am looking for is to add another Select in field for PKE_ID that has a null value.

Field:

PKE_ID

Search String:

('-')

Does not work.

Re: Actions - Select in field (search string)

sunny_talwar — Tue, 03 May 2016 12:38:01 GMT

How about this?

='(' & Concat(DISTINCT {<PBI_STATUS = {'Completed'}, PKE_ID = p({<PKE_ID = {'*'}>})>} PBI_ID, '|') & ')'