Weekly Sales in Qlik Sense

[vikasmahajan]

Dear All

Attaching weekly sales demo data please can any one explain how we can get weekly sales analysis.

Current Year                                                     Same Period Last Year

Week1            Week2  Week 3...............         Week1            Week2  Week 3...............

145200           12143                                       125300             10233

Thanks

Vikas

[devarasu07]

Hi,

like this?

Create a calculated measure like

Latest Year Current Week Sales:

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

Previous Year Current Week Sales:

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