Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Generic Table

I have built a generic table which looks like this:

Sold To Customer          2019         2020

12345                                       1                1

45678                                       1                -

67890                                       -                1

I need to be able to sum 2019 value and 2020 value and get either 1 or 2, however when I try and construct the sum(2019) + sum(2020)  I get 4039.  Doing something wrong but not sure what yet.

Thanks

Labels (1)
1 Solution

Accepted Solutions
jochem_zw
Partner
Partner

Cant see your data or model but maybe try sum([2019])+sum([2020])

View solution in original post

2 Replies
jochem_zw
Partner
Partner

Cant see your data or model but maybe try sum([2019])+sum([2020])

View solution in original post

tmumaw
Specialist II
Specialist II
Author

Darn....forgot the []   thanks.