Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
fernandoflogtz
Contributor III
Contributor III

Show 1 year ago until now

Hi All

Is possible to show 1 year of my sales, since August 2021 and 2022? because using filter, if l select aug to dec 2021 and next january to aug 2022, show me all sales of the selected years!

Im not using master calendar

 

Thank you all

Labels (6)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

A master-calendar is an essential part of all reports - therefore I suggest to implement one.

Beside this just with month and year you couldn't do such a selection else you will need to combine both fields to get unique period-information for the selection. Such creation might be done with:

monthname(Date)

or 

Year * 100 + Month

- Marcus