Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
magnusbratell
Partner - Contributor
Partner - Contributor
‎2020-12-21 09:59 AM

Bar Chart showing Selected YearMonth and same Month previous year

Hi all,

Struggling to find a good solution to this request (which seems very reasonable). Simply put, I want a bar chart that has YearMonth as dimension and two expressions as bars:

1. Sales Amount (according to selection made, expression: Sum(Sales)

2. Sales Amount for the same month, previous year

I know that this is very simple if the dimension is month (Jan, Feb, Mar etc.) but I am having trouble solving it for YearMonth. Basically, if the dimension value is 2020-03, the expression should give me the Sales Amount for 2019-03. See attached picture that contains the chart without the second expression.

Any help appreciated.

Preview file
21 KB
343 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2020-12-25 03:49 PM

For me that is more format issue? Can you use text box and identify if that is returning correct?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
307 Views
0 Likes