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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Duplicate Computations in Total Value

Hello!  Pls. help me solve my problem...I've been stuck with this issue for days...  I have a chart table that some values in my total value  (under Expressions tab) got duplicated while some were ok... My formula is just simple

  ({<Source={'Category}>}TotalValue) ....If i put the total value field in the dimensions, computaions seems ok ... But it doesn't allow me to take out the expressions 'coz it will give me 0 records..  Not sure if it has something to do with the synthetic table which I have trouble i fixing it...  I also tried switching to pivot table to no avail.

Pls. help.

Tks.


3 Replies
Not applicable
Author

try this

sum( distinct {<Source={'Category}>}TotalValue)

Clever_Anjos
Employee
Employee

you´re missing a quote after "category", did you noticed it?


sum({<Source={'Category}>}TotalValue)

Anonymous
Not applicable
Author


Thank you,  Vishwaranjan...this one works.