Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
kushalthakral
Creator III
Creator III

Make summary out of a table

Hi All

i m new to Qlikview and need some help

i have a table like below:

Where UsedImportLocalTotal
A956652656561022308
B0235658235658
C65485321502386987
D125485366987512618411
E202102321043
F03696536965
G32564533665359310
13896338784344
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.

6 Replies
cfz
Employee
Employee

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
Creator III
Creator III

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

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

Thanks

kushalthakral
Creator III
Creator III

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

Hi Kushal,

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

Regards

Carlos

kushalthakral
Creator III
Creator III

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 1ImportLocalHeader 4

Linea

Linea(Value)+Linea/Punto(0.20*Value)
Punto