Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Excel File/Cross table help

Hi - I have attached excel file and QVW ...I have one chart in the qvw but I want another Bar Chart Actual Savings by Year with

toggle by Year, show 2 bars per year (MTMActualSavings and PSOActualSavings)


Is it possible.Any help is appreciated.Thanks much.



3 Replies
dplr-rn
Partner - Master III
Partner - Master III

if i understand your issue correctly create a bar chart with 2 dimensions year, initiative

and if you want only those 2 initiatives use set analysis

sum( {<Initiative={'MTMActualSavings' ,'PSOActualSavings'}>} [Actual Savings])

apthansh
Creator
Creator
Author

Thank you but That will not work as I have different year columns.

dplr-rn
Partner - Master III
Partner - Master III

Can you explain in more detail?