topic Re: How to create Bar chart based Date field respective scenario in App Development

How to create Bar chart based Date field respective scenario

Naps_230 — Fri, 15 Nov 2024 20:58:19 GMT

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)

Re: How to create Bar chart based Date field respective scenario

Sayed_Mannan — Wed, 15 May 2024 17:44:22 GMT

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

Re: How to create Bar chart based Date field respective scenario

HirisH_V7 — Wed, 15 May 2024 18:02:07 GMT

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