Select field

Anonymous — Wed, 11 Mar 2015 12:34:14 GMT

Hi folks,

for my customer I calculate the changes of requests from one month to another (using variables). I get a set of requests.

Count( DISTINCT {$ < Berichtsdatum=,AuswahlJahr=, AuswahlMonat=,KBTyp={'Bestand'},VertragsNummer= P({<Berichtsdatum={'$(=vDatum2)'}>} VertragsNummer)-
P({<Berichtsdatum=,AuswahlJahr=, AuswahlMonat=,KBTyp={'Bestand'},Berichtsdatum={'$(=vDatum1)'}>} VertragsNummer)>} VertragsNummer)

Now I would like an easy solution to select all relevant requests. Showing the respective field will show more than the requests with above formula.

I can use the same formula in the Listbox (expression) and I do get

Request

1111111 1

2222222 1

3333333 1

...

abcdefg 0

defghijk 0

The new requests are shown with "1" in second column. Is there an easy way to select all requests with "1" in second column (without manually select them)?
WHat I weant to achieve is to select the requests and goto other charts/table to display further informationabout these requests (but without using the above forumla).

Any ideas?

Re: Select field

marcus_sommer — Wed, 11 Mar 2015 12:49:09 GMT

Maybe you could use a second listbox with an expression: if(YourExpression) >= 1, 1, 0) and used for both listboxes a container or a dimension-group - to keep the gui clean and show that both are related.

- Marcus

topic Select field in QlikView

Select field

Re: Select field