Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

How to show table data with today date by location?

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

1 Solution

Accepted Solutions
Thiago_Justen_

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))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

2 Replies
Anonymous
Not applicable

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_

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))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago