Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Associate two distinct dimensions

I'm going to try to explain my issue, but I know it will be a little abstract.  For the following table:

ProductCostInput Die

I want a bar chart that sums up the cost by product, but if there is an Input Die associated with the Product, I would also like to find that cost and aggregate it.  So, "Input Die" is not only a text attribute to "Product", but also a "Product" itself.  Ideally, I would have a bar chart with MSM9615 cost = $25 (because its Product cost is $20 and its Input Die cost is $5).

How can I do this?  Should I approach it in the chart expression or in the script editor?

Thank you!!


1 Reply
Creator III
Creator III

I would handle this in the script by loading the table again, adding another column for the cost associated with the input die.  Something like:

LOAD Product,
FROM Table;

LOAD Product AS InputDie,
Cost AS InputDieCost
FROM Table;

Then you could create an expression that adds the columns together for your bar chart.