Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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