Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to filter the tablebox by using the datefield init to get preious 30 days records
use set analysis in expression. like sum({<Date={">=$(=Max(Date)-30) <=$(=Max(Date))"}>}sales)
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
if it is in qliksense
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.