# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## How to get monthly salary and Yearly bonus in same chart?

Hi All,

I have requirement to show Monthly salary and Yearly bonus in same chart.

In Y-axis expression is like sum({<AccountDescription={salaries}>}Amount) as Monthly salary,

and sum({<AccountDescription={'Salary & Other Comp'}>}Amount) as Yearly Bonus.

For better understanding Plz see below image .

Tags (1)
1 Solution

Accepted Solutions

## Re: How to get monthly salary and Yearly bonus in same chart?

 I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.

Your data says otherwise. If the bonus amount were only available in the last month of the year you would see that reflected in the chart.

talk is cheap, supply exceeds demand
6 Replies

## Re: How to get monthly salary and Yearly bonus in same chart?

Combine the Year and Month dimensions into one dimension. The best option is to create this field in the script. If that's not an option you can use a calculated dimension: =MyYearField & '/' & MyMonthField

talk is cheap, supply exceeds demand
Not applicable

## Re: How to get monthly salary and Yearly bonus in same chart?

Thank you ,

Issue is ,Salary is month wise but Bonus is once in a year.

I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.

## Re: How to get monthly salary and Yearly bonus in same chart?

 I should get Blue dot for all month year but red colour dot(Bonus ) only at the end of each year.

Your data says otherwise. If the bonus amount were only available in the last month of the year you would see that reflected in the chart.

talk is cheap, supply exceeds demand
MVP

## Re: How to get monthly salary and Yearly bonus in same chart?

Hi

May be try like this

You can create a flag for Last Month of every year and use in the "Yearly Bonus" expression.

Ex: = if(Month = 'Dec', 1, 0) as Flag

sum({<AccountDescription={'Salary & Other Comp'}, Flag = {1}>}Amount)

Not applicable

## Re: How to get monthly salary and Yearly bonus in same chart?

Thank you ,

Honored Contributor II

Hi Mahantesh,

PFA.

Hope it works.

Regards

KC

Best Regards,
KC