Condition to exclude data

[#1]

Hello,

From the below table am trying to achieve the sequence only which has 1,2,3,4 for the test field.

Having a challenge to create the condition to exclude which doesn't have all the 4 Sequences in the script.

It would be great if someone can help on how to restrict test field values which doesn't have all the 4 seq as mean a test field value should have all the 4 seq (i.e, 1,2,3,4 should be present if not restrict).

test	seq
116425	2
129561	2
129561	3
139697	2
139697	3
161410	2
174989	2
220020	1
220020	2
221035	2
229783	2
232599	1
237923	2
237923	3
237952	2
238887	2
10200010	4
10202181	1
10202181	2
10202181	4
10202445	3
10202181	1
10202181	2
10202181	3
10202181	4

Thanks in advance.

[MarcoWedel]

Hi,

one front end solution could be a listbox using this expression:

=Aggr(Concat(DISTINCT seq,','),test)

hope this helps

regards

Marco

[Kushal_Chawda]

Toh ek where daal denge.. where seq<=4

[#4]

see attached qvw

[#5]

Sorry for the delay in response.

Sunny- the solutions works accurate Thanks, now the challenge is that user wanting to change the seq range dynamically on UI.

For instance if a user would like to Seq for only 1,2,3,4,5 they would like to have this as on the fly.

Any thoughts on this.

[sunny_talwar]

You mean that all the data will already be in the application (for all test) and we would need to show only those test where all the seq exists for the user entered list of seq?

[#7]

Sorry for the delay with the response.

I had another challenge that now the user would like to have a dynamic option of changing the Seq range.

An instance like if a user would like see only Seq between 1,2,3,4,5,6.

Any advise please.

Thanks in advance with the help.

[#8]

So the way i am thinking should is not sure if possible, but when a user select a value from the list box which has all the seq values from lets say 1 thru 10.

When a user will select 4 that should show all the test field values which has seq from 1 thru 4.

If this is quite not possible then some way where a user don't need to go for more clicks on the screen to render the specific seq range.

Hope i answered your question.

Thanks.

[sunny_talwar]

May be you need a And-mode selection. Look at this

Read about And-Mode here: AND-Mode

[MarcoWedel]

maybe using the principle of the As-Of-Table?

[#11]

Thanks  Sunny.

This might be it.

I will testing this in for next few days for the possibility integrating the change into Application.

Appreciate the help.

Thanks.