Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

expression help

hi,

i created a straight table containing fields like transacation type, today's transaction, yestreday tx count, last 7 days count, last 28 days count

i have given the dimension as transaction type and in expressions other 4.

for Todays tx i have written an expression like :     =sum({<Day={"=Num(Max(Day))"}>}SumofTxn)

For yestredays i ahve written an expression like :   sum({<Day={"=Num(Max(Day)-1)"}>}SumofTxn)

but for other two i am not getting how to write expression.

please help

11 Replies
srujanaponnuru
Creator
Creator
Author

all last 7 days

tresesco
MVP
MVP

Try like:

Today : =sum({<Day={"$(=Max(Day))"}>}SumofTxn)

Yestesrday : =sum({<Day={"$(=Max(Day)-1)"}>}SumofTxn)

Last 7 days : =sum({<Day={">$(=Max(Day)-7) <=$(=Max(Day))"}>}SumofTxn)

Last 28 days : =sum({<Day={">$(=Max(Day)-28) <=$(=Max(Day))"}>}SumofTxn)

Note: If you select any date field and wish to see corresponding result, you might have to pass that field in all the set expressions like:

Yestesrday : =sum({<Date, Day={"$(=Max(Day)-1)"}>}SumofTxn)