Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JorgeFra81
Contributor II
Contributor II

SUM in TABLE

Hi,

I am trying to get a sum inside a TABLE. But I could not get the desired result.

I have tried these options:

Dimension: PAX_TOTAL_DEPARTURE 

Measure_ =Sum(PAX_TOTAL_DEPARTURE)

What I need is when I filter by Base I would like to obtain the Sum of the PAX_TOTAL_DEPARTURE by Base, but I only got the total number of PAX, same numbers for all Bases and it shouldn't be.

I will really appreciatte any help

sum in table.JPG

2.JPG

 

9 Replies
dplr-rn
Partner - Master III
Partner - Master III

why do you have PAX_TOTAL_DEPARTURE  as a dimension?

JorgeFra81
Contributor II
Contributor II
Author

Hi, 

In the second picture I have it as measure. I just said I have tried both cases.

Dimensión:Expression

Medida:Measure

3.JPG

dplr-rn
Partner - Master III
Partner - Master III

hard to diagnose with out more detail

but when a simple sum(column) shows full today that means an issue in the data model i.e. that column PAX_TOTAL_SALIDA is not related to other columns in that table

JorgeFra81
Contributor II
Contributor II
Author

I just made a translation for you.

It is better that you take a look at the qvf file BAGGAGE, and the sheet BAGGAGE RATIO.

Thanks for your time!

JorgeFra81
Contributor II
Contributor II
Author

Maybe I have to use another kind of function.

Kirsten
Creator II
Creator II

If you click on the table, on the right side under Data: if you click on a measure and it opens up you can set the Totals function on SUM

See attachment. Does this work?

JorgeFra81
Contributor II
Contributor II
Author

Hi Kirsten,

I havve checked and it is on AUTO for Total Function.

4.JPG

Kirsten
Creator II
Creator II

ok is the issue herewith resolved?

JorgeFra81
Contributor II
Contributor II
Author

I am afraid it is not solved.

I should get this kind of results:

5.JPG

 

To obtain these results I have inserted this table, but this is all the results tipped by me.6.JPG

🤔