Make summary out of a table

[kushalthakral]

Hi All

i m new to Qlikview and need some help

i have a table like below:

Where Used	Import	Local	Total
A	956652	65656	1022308
B	0	235658	235658
C	65485	321502	386987
D	12548536	69875	12618411
E	20	21023	21043
F	0	36965	36965
G	325645	33665	359310
	13896338	784344	14680682

and i actually waana make a summary out of it

where i need to add B's Import value and 20% of G's Import Value

Please help.

Regards

Kushal T.

[cfz]

Hi Kushal,

You can use an expression like

=sum({<[where used]={B}>}import)  +

sum({<[where used]={G}>} 0.2*import)

as in the attached example

Regards

Carlos

[kushalthakral]

Hi Carlos

i have tried but actually i want to show the summary in another table and in that case it is not working

please help

[cfz]

Can you upload a picture or explain a bit more how the summary table is supposed to look like?

Thanks

[kushalthakral]

hi carlos

i have attached the qvd

in first table u will find the details

and i want to create a summary like if model is linea and linea and Punto then Total Value is Linea + 0.2(Linea and Punto)

Regards

Kushal

[cfz]

Hi Kushal,

I am not sure I have understood you correctly but I hope this is what you are looking for.

Regards

Carlos

[kushalthakral]

hi carlos

thanks for you efforts but actually the requirement is like

if there are model like linea and linea * xxx

then i have to add Linea + 0.20% of Linea * xxx

and show it like

Header 1	Import	Local	Header 4
Linea	Linea(Value)+Linea/Punto(0.20*Value)
Punto