Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
MVP

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...