topic Filter values in QlikView

Filter values

Mon, 22 Sep 2014 07:00:19 GMT

Hello everyone,

So I have a small problem showing some data on qlikview.

I have a example attached.

On this example you can see a table box with some results that come from an excel sheet.

On the first two rows all the values are the same except for the values of column_7.

What I would like to know is how can I show only one of these lines (the first two), preferably the one with the smaller date.

Can anyone help?

Thank you in advance!

Best regards!

P.S. I have a personal version of qlikview so if anyone changes something and sends to me with the pro version of qlikview I wont be able to open the document.

Re: Filter values

tresB — Mon, 22 Sep 2014 07:13:03 GMT

Ivo Marques wrote:

...

What I would like to know is how can I show only one of these lines (the first two), preferably the one with the smaller date.

Assumg, you meant smaller column_7 value.

Take a straight table:

dimensions: all six coulmns

expression: Min(column_7)

Re: Filter values

geert_gelade — Mon, 22 Sep 2014 07:13:19 GMT

I think you can use a straight table instead of table box.

select the 6 columns as dimensions and as exrpession set "min(Column_7)".

Result:

Re: Filter values

ashfaq_haseeb — Mon, 22 Sep 2014 07:16:01 GMT

Hi,

Create new chart --> Straight table

Dimensions

Column_1

Column_2

Column_3

Column_4

Column_5

Column_6

Expression

=min(Column_7)

Regards

ASHFAQ

Re: Filter values

Tue, 23 Sep 2014 07:35:18 GMT

Hello gentleman,

The solution provided worked.

Thank you for the help!

Regards