Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Contributor III
Contributor III

Can't manage to sum a calculation

Hi all 

I have a problem with one of the calculations in my straight table.

The field internal use is calculated like this:   =if(Internal_Use>0,Internal_Use,0)

It is an already summed field.

For some reason it shows me only the unique values of the internal use field (1,3)

aheavy95_0-1662476776416.png

 

Only when I add the Date field I get the whole records:

aheavy95_1-1662476909320.png

My goal is to get the sum of the records which for this product in 2022 is 8, and not each row seperately. 

Anyone has an idea?

Thanks

Alon

Labels (1)
2 Replies
BrunPierre
Specialist II
Specialist II

What is the expected  O/P?

Fernando_Fabregas
Creator II
Creator II

Hi!

In your table, add a column as Measure, with:

Sum(Internal_Use)

Tables in Qlik group dimensions and show only one row per distinct value.

If you need to show the same rows as is in your model, you will need to add more columns, like a unique ID or RowNo().

Regards, Fernando