Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

table box

how to filter the tablebox by using the datefield init to get preious 30 days records

4 Replies
Anonymous
Not applicable
Author

use set analysis in expression. like sum({<Date={">=$(=Max(Date)-30) <=$(=Max(Date))"}>}sales)

vinieme12
Champion III
Champion III

You cannot add expressions to a TableBox, you need to use either a Straight Table or a Pivot table for adding expressions

sum({<Date={">=$(=Max(Date)-30) <=$(=Max(Date))"}>}sales)


Refer this Post for working with dates

Dates in Set Analysis

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

if it is in qliksense

Anonymous
Not applicable
Author

There is no table box in Sense, there is Table, which is the equivalent of Straight table in QV.  So, the above answers are relevant.