topic Re: Compare current field value vs column max in QlikView

Compare current field value vs column max

Fri, 02 Oct 2015 13:38:36 GMT

Hi guys,

May seem a very simple question to most of you but I am not getting around this.

I have a table with columns A, B, C, D and I what to show values only if the value of the current row of C matches the max value of the column C

so if A, B, C,D

1, 2, 3, 4

1, 4, 5, 6

7,8, 5, 3

I want to show only the last two rows.

Thanks

hic — Fri, 02 Oct 2015 18:20:33 GMT

If you want to do this in the UI, you can create a pivot table with an appropriate dimension - RecNo or something - and use the following expression

If(Only(C) = Max(total C), <your expression>)

If you want to do this filtering in the script you can use

Table:

Load * From SourceTable (...) ;

Inner Join (Table)

Load Max(C) as C Resident Table;

HIC

Anonymous — Fri, 16 Oct 2015 06:13:14 GMT

You can create a variable that holds maximum value in C column, something like vMaxC=Max(C)

Create a straight chart and display the columns whenever the column value is more than your vMaxC...

Hope this helps.

Regards,

Laxmi

Sun, 18 Oct 2015 16:10:03 GMT

I guess to use it like that one should be careful as when the selection changes the value of the variable changes as well