Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
scotly-victor
Creator II
Creator II

Previous Month for Current Year

I wanted to show 2 line chart

1.current year current month

2.current year previous month.

Dimension:Month

My current Year current month expression is

sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>} Sales) (works fine)


My current Year previous month expression is


=(above(Sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>}Sales ))) (issue)



If I use above expression till may (right to left) I am getting precise value ,however  apr is null,


Can any one help me?

11 Replies
Anonymous
Not applicable

how to get before six month data using expression

Anonymous
Not applicable

i want to show previous rating and current rating in chart by resource name? i have start date and end date for that ratings

which is for 6 months