Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

Weekly Sales in Qlik Sense

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

1 Reply
devarasu07
Honored Contributor II

Re: Weekly Sales in Qlik Sense

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])

Capture.JPG