topic Re: Totals by Dimensions in QlikView

Totals by Dimensions

Thu, 07 May 2015 06:32:22 GMT

I have a database output like below. And I got same output in to Qlik via SQL query.

Customer	Item	Quantity
10001	Milk	10
10002	Milk	8
10001	Eggs	4
10002	Eggs	4

My desired output is below. I would like to do this via Qlik. Or I would like to compute Total qunatity, Milk qnt, and Eggs qnt via Qlik Expressions. Is it possible? Please help


Customer	Total Quantity	Milk Quan	Eggs Quan
10001	14	10	4
10002	12	8	2

Re: Totals by Dimensions

avinashelite — Thu, 07 May 2015 06:35:07 GMT

use pivot table , this will help you to get the desired format. Pivoting on the item column

Re: Totals by Dimensions

tresB — Thu, 07 May 2015 06:36:57 GMT

Straight table.

Dimension: Customer

Exp1: Sum(Quantity)

Exp2: Sum({<Item={'Milk'}>}Quantity)

Exp3: Sum({<Item={'Eggs'}>}Quantity)

Or, if you have many Items, you could do it dynamically using pivot table enabling partial sum (for total) in the presentation tab.

Re: Totals by Dimensions

Anonymous — Thu, 07 May 2015 06:37:49 GMT

Add Custoimer as dimension and below 3 expressions in your chart

for Total Quantity= sum(Quantity)

Milk Quantity = sum({<Item={'Milk'}>}Quantity)

Eggs Quantity = sum({<Item={'Eggs'}>}Quantity)

Regards,

Greeshma

Re: Totals by Dimensions

jagan — Thu, 07 May 2015 06:55:14 GMT

Hi Murali,

I think Pivot table is the best option

Dimension: Customer, Item

Expression: Sum(Quantity)

Enable Partial total in presentation mode

and drag the Item dimension to top.

Regards,

Jagan.

Re: Totals by Dimensions

sunilkumarqv — Thu, 07 May 2015 07:15:23 GMT

@Hi muralidhar

Plz find the attached

Re: Totals by Dimensions

Thu, 07 May 2015 16:33:06 GMT

Thank you all.Great communuty and helping us to learn Qlik with light speed.