Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to compare current period sales to last year sales

I have a company with a year end of 31 March.

I have an excel spreadsheet with data for the following fields

Date

Invoice number

Period number

Sales value

I want to create a KPI showing

Sales for last month

Sales for  last month last year

Sales year to date to last period for this year

Sales year to date to last period for last year

Can anyone help or put me in the direction of any tutorial videos


thanks


Ian

3 Replies
MVP
MVP

Re: How to compare current period sales to last year sales

May be look into this:The As-Of Table

reddys310
Honored Contributor II

Re: How to compare current period sales to last year sales

Hi Ian,

Check this out:

This should help answer some of your questions:

Creating A Master Calendar

Thanks,

Sangram.

satishkurra
Valued Contributor II

Re: How to compare current period sales to last year sales

If you are looking for QLikSense part, Please refer the attached document...