topic Filtering on the data of a column in QlikView

Filtering on the data of a column

Mon, 05 Jul 2010 11:48:26 GMT

Hi all,

I did a pivot table and now I'd like to build a listbox based on the values of one of its column. Is there a way to do that?

Thanks a lot.

Filtering on the data of a column

Mon, 05 Jul 2010 15:17:10 GMT

Does someone know if this is possible at least? Thanks.

Filtering on the data of a column

Mon, 05 Jul 2010 17:24:43 GMT

Yes, it depends on the case you could use a "select field" with an expression.

You could try by adding any field to the sheet and then change the origin to Expression.

Filtering on the data of a column

Tue, 06 Jul 2010 08:57:26 GMT

Thanks a lot for your answer. Unfortunately I already tried that without success. The Expression which I want to show in the list box is:

Only({<ReceivedDate={'$(vForecast1)'}>}ShippingMode) & ' -> ' & Only({<ReceivedDate={'$(vForecast2)'}>}ShippingMode)

It produces string like this: "Sea -> Land" or "Air -> Sea"; using the dates contained in the two variables vForecast1 and vForecast2 I'm showing how the shipping mode changed from a date to another one. Now I'd like to filter on that column to show only (as an example) the shipments which changed from Sea to Air mode (string "Sea -> Air").

If I try to copy and paste that Expression in a ListBox, it simply doesn't show nothing. Do you please know a way to do that?

Thanks!

Filtering on the data of a column

Tue, 06 Jul 2010 13:32:23 GMT

It would be easy if I have a copy of the structure, but I will try without it.

Try an expression like this:


AGGR(Only({<ReceivedDate={'$(vForecast1)'}>}ShippingMode) & ' -> ' & Only({<ReceivedDate={'$(vForecast2)'}>}ShippingMode), DIMENSION)

Where DIMENSION is/are the dimensions on your table (or something that makes unique the shipping mode on a row).

Hope it helps!

Filtering on the data of a column

Tue, 06 Jul 2010 13:58:34 GMT

Hi Jeremias, thanks again for your answer, unfortunately it doesn't work. Attached is what I'm working on. I need to have a listbox to filter the values on the column called "Shipping mode". Do you think that's possible? THANKS 🙂 !

Filtering on the data of a column

Tue, 06 Jul 2010 15:28:32 GMT

Hey B, this is what I was talking about.

Anyway, I think you should do "CONCAT([Ship Mode],'->')" instead of only(), it will work better and will concatenate all of your shipping modes.

Hope it helps!

Filtering on the data of a column

Tue, 06 Jul 2010 16:10:14 GMT

Yes, ti works! THANKS, THANKS, THANKS

P.s.:I can't guess how you would use concat in my particular case.