Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to show last week(in date),last month,last quarter sales in qlikview

Hi,

I have orderdate data.i need to show

       1)in dimension last week(seven days dates) as dimenstion and sales as expression.

      

       2)last month(30 days dates) as dimension and sales as expression

       4)last quarter(90 days dates) as dimension and sales as expression.

Could you please suggest me the how to write in dimension and expression one by one.(make sure that dates will be displayed on

charts as dimesion based on last week and month and quarter.

Thanks,

yuvraj

1 Reply
dhanaji_roman
Partner - Contributor II
Partner - Contributor II

Hi..Rajesh..

You can use below links for your referance..

YTQ, QTD, MTD and WTD

Previous YTQ, QTD, MTD and WTD

Regards,

Dhanaji Roman..