Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

I need expression for Current Financial Year vs Previous Financial Year in bar chart

Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?

4 Replies
Highlighted
MVP
MVP

Highlighted
Master III
Master III

You can assign a variable wich takes value as getcurrentselected Year or by default maxYear

Now you need to use two expression one with set analysis of current year and one with set analysis with curent year -1

Highlighted
Specialist III
Specialist III

Dear Balasun,

Kindly, find attached document.

Kind regards,

Ishfaque Ahmed

Highlighted
Not applicable

Dimension=Year


Expression

=Sum({$ <Year = {Year(today()), Year(today())-1}> }Sales)


I hvnt tested but it shall work