How to create Bar chart based Date field respective scenario

[Naps_230]

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)

[Sayed_Mannan]

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

and then choose Year and month in the same bar chart

[HirisH_V7]

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