Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gerrycastellino
Contributor III

Showing previous period sales in same row as current

In my straight table, on the same row as the current, I'd like to show the previous months sales, or the last years period sales.

How would I structure my expression for this ?

Gerry.

PrevPeriod.PNG

3 Replies
antoniotiman
Honored Contributor III

Re: Showing previous period sales in same row as current

Hi Gerry,

if You use QV 12 then

Aggr(Above(TOTAL Sum({<Date>} Sales)),(Date,(Numeric,Asc)))

Regards,

Antonio

miranrai
New Contributor III

Re: Showing previous period sales in same row as current

see here attached. !

kavita25
Valued Contributor

Re: Showing previous period sales in same row as current

Community Browser