topic Re: Select in field: How to use Search String? in QlikView

Select in field: How to use Search String?

Thu, 23 May 2013 09:00:52 GMT

I have something which looks like the below at the moment:

In English I would like to select the field "c_Cinema" which has the minimum "d_DistanceApart_Miles"

c_Cinema is a string, d_DistanceApart_Miles is an int.

Data would look like so

Cinema 1 - 1 miles

Cinema 1 - 1.5 miles

Cinema 2 - 4 miles

Cinema 2 - 4.5 miles

etc...

Could anyone help me out?

sushil353 — Thu, 23 May 2013 09:11:16 GMT

Please find the attached application:

=Only({<d_distance={$(=min({1}d_distance))}>} c_cinema)

HTH

Sushil

er_mohit — Thu, 23 May 2013 09:35:57 GMT

Try this

sum({<d_distance={"$(=min(d_distance))"}>} c_cinema)

only({<d_distance={"$(=min(d_distance))"}>} c_cinema)

Thu, 23 May 2013 10:26:13 GMT

Hey this is close.

referring to my example again

Cinema 1 - 1 miles

Cinema 1 - 1.5 miles

Cinema 2 - 4 miles

Cinema 2 - 4.5 miles

This seems to be returning me

Cinema 1 - 1 miles

How can I make sure I include all cinemas in the current selection?

e.g. return

Cinema 1 - 1 miles

Cinema 2 - 4 miles?

er_mohit — Thu, 23 May 2013 10:31:27 GMT

Try this

sum({1<d_distance={"$(=min(d_distance))"}>} c_cinema)

only({1<d_distance={"$(=min(d_distance))"}>} c_cinema)

or this

sum({1<d_distance={"$(=min({1}d_distance))"}>} c_cinema)

only({1<d_distance={"$(=min({1}d_distance))"}>} c_cinema)