Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis - Error in set modifier ad hoc element list

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

=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

1 Solution

Accepted Solutions
MVP
MVP

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

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.

6 Replies
Not applicable

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

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!

Not applicable

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

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

MVP
MVP

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

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.

Not applicable

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

That worked!!  Thanks a ton!

Not applicable

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

How about -

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

?

jlrzz222
New Contributor

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

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)

Community Browser