Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
apthansh
Contributor

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

Re: Excel File/Cross table help

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
Contributor

Re: Excel File/Cross table help

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

Partner
Partner

Re: Excel File/Cross table help

Can you explain in more detail?