Dimension , as a result of sum others dimensions

[fkeuroglian]

Hi , i would like to know what is the best way to achieve this

i attached an image to show what i want in qlikview,

what do you suggest? have any idea or example? what technique i have to use?

see the attached

thank you a lot

Fernando

[swuehl]

Could it be just a total line (set option 'Totals on last row' and proper label on presentation tab)?

Or maybe each line an expression with straight table chart set to 'horizontal'?

Or something else depending on your data model, data and expressions behind?

If above doesn't really help you, I think it would be easier if you could post a small sample that shows data close to your data model and a chart matching your current one.

[its_anandrjs]

Hi Fernando,

By the use of the Pivot table you can create this type of the charts and use only expressions in the chart do not use the dimensions in the chart. Use your expression what ever it is i explain this with a example here.

Exper1:- Sum([Gross Sales])

Exper2:- Sum([Sales Return])

Exper3:- Sum([Off Invoice Discounts])

Exper4:- Sum([Sales Promotions])

Exper5:- Column(1)+Column(2)+Column(3)+Column(4)

And you get this type of the chart

[fkeuroglian]

Anand i can achieve as your example

please see the qvw whit a little example , sure i am doing something wrong

thank you a lot

Fernando

[swuehl]

Here is a sample using Nivel as dimension and sum(Total) as expression, then just use the relabeled total line.

[its_anandrjs]

You can take straight table and

Dimension:- Nivel1

Expression:- Sum(Total)

[its_anandrjs · Accepted solution]

In this you can use the pivot table also but you have to write 6 expressions

LOAD Nivel1,

          //Total,

          Total as TotalValue

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

=Sum( {<Nivel1 = {'Administrativo'}> } TotalValue)

=Sum( {<Nivel1 = {'Comercial'}> } TotalValue)

=Sum( {<Nivel1 = {'Finanzas'}> } TotalValue)

=Sum( {<Nivel1 = {'Sueldos'}> } TotalValue)

=Sum( {<Nivel1 = {'Licencias'}> } TotalValue)

=Column(1)+Column(2)+Column(3)+Column(4)+Column(5) //NET SALES

[fkeuroglian]

Thank you a lot!

I find other solution that works OK too

http://www.visvero.com/uncategorized/qlikview-subtotaling-customization-part-2/

Thank you anand,swuelh