Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Ther_Rider
Contributor II
Contributor II

Need current Year Bar chart and previous years Line chart

Dear,

 

Help me to prepare below chart using attached data

 

Chart:

Ther_Rider_0-1707470640457.png

 

 

 

Labels (1)
2 Replies
rubenmarin

Hi, I you can use a combo chart with differnt expressions for bar and each line, using set analysis to filter the value to pick for each one, like: Sum({<FY={'2022 - 23'}>} Value)

In the measure, with the 'more properties' button you can selct to show the measure as bar or line, and set allthem to the left axis.

rubenmarin_0-1707550235866.pngrubenmarin_1-1707550255616.png

 

anat
Master
Master

As suggested by @rubenmarin use combo chart

Dimension as Month

Measure1: bar

Measure2: line

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Visualizations/Combo...