Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total of the expression.

Because the sum in the TOTAL column values ​​do not match?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I managed to solve:

replace the column formula TOTAL :

sum( (VENDA*12)/(360/((ESTOQUE/VENDA)*30)))

thank you...

View solution in original post

6 Replies
swuehl
MVP
MVP

Sorry, you probably need to add what you want to see...

If you want to see values for 2011 and 2010 resp., you could use the set expressions that are commented in your expressions, already in your application. Then values seem reasonably to me, also Teste3.

Maybe I just don't understand what you are after.

Anonymous
Not applicable
Author

Note that the

01 month / 2,011 = 120.00,

02 month / 2011 = 280.00.

The total should be 400.00

swuehl
MVP
MVP

Ah, you are talking about CONCEPTO=TESTE2 ?

03 month / 2011 is 30 and I get a total for the year of 430. If I select only 01 month and 02 month, I get 400 displayed. Not what you expected?

Anonymous
Not applicable
Author

I managed to solve:

replace the column formula TOTAL :

sum( (VENDA*12)/(360/((ESTOQUE/VENDA)*30)))

thank you...

swuehl
MVP
MVP

Good to hear that you solved your problem.

Since I can't see a column TOTAL in your attached sample file, I think you are maybe referring to a different app. Would explain some things..

Anonymous
Not applicable
Author

Sorry, I have attached the wrong application, follows the new.