Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

howto: sum a data list

Hi Community,

could you help me?

A table contains these values:

Name                     Number

BOOK 1      ........... 20

BOOK 2 ................. 4

A12345 ...............    34

G45677 .................. 3

901020 ................   34

FRUIT ................. 34

DISK ..................  123

H12497 ..............    3

HowTo sum only:

A12345

G45677

901020

H12487

11 Replies
sunny_talwar

Not sure I understand your followup question?

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

A table contains these values:

Name                     Quantity 1                Quantity2

BOOK 1      ........... 20                                   0

BOOK 2 ................. 4                                    0

A12345 ...............    34                                5

G45677 .................. 3                                  4

901020 ................   34                                5

FRUIT ................. 34                                    0

DISK ..................  123                                  0

H12497 ..............    3                                   3

The formula should be:

1) create a table (table1) containing ONLY values (A12345, G45677, H12497) 

please note that table contains hundreds of values and it's impossibile to list them

2) create a new formula

if Name is equal to one of those present in the table1, (quantity1 + quantity2), quantity1