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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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