Weekly Sales

[gisellevaleta]

Hi Everyone,

I'm new to qliksense and am battling abit with building expressions.

I have a date (day, week, month, year) field and a nett sales (total sales) field.

How do I build an expression to just return sales for the week?

[Chanty4u]

which week sales you want?

this takes you current week

Sum({$<Year={"$(=max(Year))"},Week={"$(=max(Week(Date)))"}>}[Sales])