topic Re: Filtering a variable in QlikView

Filtering a variable

Mon, 21 Jan 2013 11:19:15 GMT

Hi Guys,

Ok so basically what im trying to do is get the Maximum date of a specific field in a variable

Set LastUnconfirmedSaleDate= =max( { 1 <Product={'*'}> , <ref = {'U'}>} Dates);

it must be for all products and the ref must be for U can someone correct my syntax/Logic ?

Regards

Curt

Re: Filtering a variable

Anonymous — Mon, 21 Jan 2013 11:31:47 GMT

You don't need the middle angled brackets, so try:

Set LastUnconfirmedSaleDate= "=max( { 1 <Product={'*'},ref = {'U'}>} Dates)";

Jonathan

Re: Filtering a variable

jagan — Mon, 21 Jan 2013 12:53:19 GMT

Hi,

Try this

LET LastUnconfirmedSaleDate= max( { 1 <Product={'*'} , <ref = {'U'}>} Dates);

Regards,

Jagan.

Re: Filtering a variable

Mon, 21 Jan 2013 13:36:46 GMT

Thanks that works , slightly off topic but is there a way to get the sum from only a single table

I.E. Set TotalAgents= =count({1} salesCode); I only want the count of salescode from oen table(agents) and not from the joining tables so i basically want to excludes sales codes from any other tables

Re: Filtering a variable

Anonymous — Mon, 21 Jan 2013 13:42:11 GMT

When you load in your tables create a duplicate of the field you are interested in, on the table you're interested in, and count that instead.

Else you can create a field with a value of 1 and do a sum on that field. That would be more efficient.

Jonathan