Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total function in chart

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.

Chart QlikVIew Community.png

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

3 Replies
sunny_talwar

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)

Not applicable
Author

Sunny T,

It worked very well.

Thanks a lot!!!!

sunny_talwar

Great