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: 
simoevry
Contributor
Contributor

total in dimension and mesure on straight table

Hi guys,

I've problem with total If someone here could helpme .

this is my expression :

((MIN(Valeur)-Above(Max(Valeur))))/100

aa.PNG

 

thank you !!

 

 

 

 

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))

View solution in original post

11 Replies
sunny_talwar

What exactly is the issue? Can you elaborate with an example from the image you have posted?

simoevry
Contributor
Contributor
Author

Hi Sunny

Normally I must got this result in total columns for example : 115,04+99,20=214,20

 

 

clipboard_image_0.png

sunny_talwar

Try this

Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))
simoevry
Contributor
Contributor
Author

It's works for me thank you so much Sunny 😊

simoevry
Contributor
Contributor
Author

I still have this issue when I wanna Deselect the selection, I 've seen the total not correct with negative value bellow

attachement :

 

aa.PNG

sunny_talwar

What does the total need to show? Sum of rows?

simoevry
Contributor
Contributor
Author

I need both of them
sunny_talwar

Both of them? What do you mean?

simoevry
Contributor
Contributor
Author

I need to show total row and columns It's work but when I deselect the selection [Hour1], I got negatives values.

You can find the attachement bellow.

aa.PNG