Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Creator
Creator

How to create Bar chart based Date field respective scenario

Hi All,

I have data like below table .

Product  Date Sales
A 5/15/2024 100
A 4/16/2024 80
A 12/20/2023 70
A 11/20/2023 60

 

i need to show data in Bar like X axis should be (last year, Current year, Last month 2024,Current month 2024)

Measure= Sum(Sales)

Naps_230_0-1715787330791.png

 

2 Replies
Sayed_Mannan
Contributor III
Contributor III

I'm not sure whether you can show in that way but instead you can use alternative dimensions option 

Screenshot 1.png

and then choose Year and month in the same bar chart

Screenshot 2.png

 

HirisH_V7
Master
Master

Hi You can create a Synthetic Dimension using Below ,

 

Dimension  :  valuelist('2023','Current Month','Last Month','2024')

Measure : If(valuelist('2023','Current Month','Last Month','2024')='2023', Your Expression and Etc.

 

Ref:

https://community.qlik.com/t5/Design/ValueList-For-those-tricky-situations/ba-p/1476275

 
HirisH
“Aspire to Inspire before we Expire!”