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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
slribeiro
Partner - Creator
Partner - Creator

Chart dimensions

I have 3 tables automatically joined in one fact table because all of them have the same fields (quantity, type and value)

Imagine this tables are product1, product2 and estimate.

I want to make chart that compares the value of product1+product2 with estimate in the dimensions...

Thank you in advance for any help you can give me.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps an expression like rangesum(sum({<Type={'product1'}>}value), sum({<Type={'product2'}>}value), -sum({<Type={'estimate'}>}value))


talk is cheap, supply exceeds demand