Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

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.

Tags (2)
1 Reply

Re: Chart dimensions

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

talk is cheap, supply exceeds demand
Community Browser