topic Re: Set Analysis - Error in set modifier ad hoc element list in QlikView

Set Analysis - Error in set modifier ad hoc element list

Thu, 02 Aug 2012 16:36:45 GMT

What I want to do is display chart data for the last date in a table.

I've tried all of the various methods to get this to work in a chart as an Expression, but either I get an error or 'No data to display'.

=sum({1<T_PageViewDate = {'$(=Max(T_PageViewDate))'}>} T_ErrTypTotal) == no data

=sum({1<T_PageViewDate = {$(=Max(T_PageViewDate))}>} T_ErrTypTotal) == no data

=sum({1<T_PageViewDate = {=Max(T_PageViewDate)}>} T_ErrTypTotal) == error

Even using the Set Analysis wizard, the result yields "No data"

=Sum({$<T_PageViewDate={$(=Max(T_PageViewDate))}>}T_ErrTypTotal)

If I do a simply = Sum(T_ErrTypTotal), it works, but I get all of the data, not just for the date I want.

Thanks,

-- Matt

Thu, 02 Aug 2012 16:43:40 GMT

Hi Matt,

Would it be possible to attach a reduced version(scrambled if it's sensitive data), as it will be easier to test.

Cheers!

Thu, 02 Aug 2012 16:45:22 GMT

I don't know how to do a reduced set or scramble it. Sorry...still quite a newbie.

swuehl — Thu, 02 Aug 2012 16:45:43 GMT

Could be a problem with date format mismatch, try using an appropriate date format with your dollar sign expansion:

=sum({1<T_PageViewDate = {'$(=Date(Max(T_PageViewDate)))'}>} T_ErrTypTotal)

if T_PageViewDate is formatted with your standard date format (otherwise state the format needed in Date() function as second argument.

Thu, 02 Aug 2012 16:48:36 GMT

That worked!! Thanks a ton!

Thu, 02 Aug 2012 16:49:12 GMT

How about -

sum(aggr(max({$<T_PageViewDate= p(T_PageViewDate) >} T_ErrTypTotal),id))

jlrzz222 — Mon, 26 May 2014 22:54:42 GMT

Good afternoon,

could please help me, I have the same problem but I can not seem to solve.

with the following problems:

= Sum ({1} = {$(=Date(Max(FechaFacturacion)))}> <FechaFacturacion ItemValorVenta)

= sum ({<FechaFacturacion={$(=(Min(FechaFacturacion)))}> ItemValorVenta)

= Sum ({1} = {'$(=Date(Max(FechaFacturacion)))'}> <FechaFacturacion ItemValorVenta)