topic Re: The chart can't display the data in QlikView

The chart can't display the data

Mon, 04 May 2015 03:02:12 GMT

Hi~Guys:

This week expression = Max (aggr (sum ({< week = {$(= Max (week))} >} peak flow rate), time, total business)), there is data display;

Last week the expression = Max (aggr (sum ({< week = {$(= Max (week) - 1)} >} peak flow rate), time, total business)), suggests that unable to display the data;The problem how to solve;

Only one table data source, and extract data every day, week this field according to the time field points out;Inside the expression means: find out this week maximum peak flow rate;

Re: The chart can't display the data

sunny_talwar — Mon, 04 May 2015 15:18:43 GMT

Try this may be:

=Max(Aggr(Sum({<week = {"$(=Max(week))"}>} peak flow rate), time, total business)) and

=Max(Aggr(Sum({<week = {"$(=Max(week) - 1)"}>} peak flow rate), time, total business))

Best,

Sunny

Re: The chart can't display the data

Tue, 05 May 2015 04:12:21 GMT

=Max({<week=>}Aggr(Sum({<week = {$(=Max(week) - 1)}>} peak flow rate), time, total business));

{<week=>},I am so careless;