topic Re: Total function in chart in QlikView

Total function in chart

Wed, 20 Jan 2016 19:47:24 GMT

Hello to all,

I'm having some issues on the creation of a chart with the % of expenses for my 3 years database.

I have the following kinds of expenses:

Administration;

Computer;

Distribution;

Production;

Selling;

Technical.

I wish to build a line chart in which each line stands for each kind of expense, as the % of the total.

I made a brief, in a child way, to demonstrate the chart I need.

In my Dashboard, the Year field is always selected, so, it's something to take into consideration that makes it harder to set a good set analysis.

Thanks a lot guys!!!!!!

sunny_talwar — Wed, 20 Jan 2016 20:19:07 GMT

May be this:

Sum({<Year, Expenses = {'Administration'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Computer'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Distribution'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Production'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Selling'}>}Expenses)/Sum({<Year>}Expenses)

Sum({<Year, Expenses = {'Technical'}>}Expenses)/Sum({<Year>}Expenses)

Thu, 21 Jan 2016 11:45:59 GMT

Sunny T,

It worked very well.

Thanks a lot!!!!

sunny_talwar — Thu, 21 Jan 2016 18:05:24 GMT

Great