How to show table data with today date by location?

[siva_boggarapu]

Hi

I Need to optimize Qlik Sense dashboard, app is extremely large with raw data sets which are

expected to continue to grow. Final metrics table should be reduced to daily resolution by location.

How to reduced data with respect to today date and location

Thanks,

Siva

[Anonymous]

Hi Siva,

I am assuming you application is Sales . Based on the max(Posting Date)..you can restrict the data. Use this in expression to show the data.

If this is wrong give me an example..

Regards,

Sadasiva

[Thiago_Justen_ · Accepted solution]

Siva, you can use this trick if you want to show only today's data:

E.g: Sum (Aggr (Sum ({<FIELD_DATE={"$(=Today ())"}>}YOU_MEASURE),Position))

Or maybe this one to show everything grouping by position:

Sum (Aggr (Sum(YOUR_MEASURE),Position))