topic Re: Calculated/Conditional Dimension Question in QlikView

Calculated/Conditional Dimension Question

joe_mccorkel — Tue, 15 Mar 2016 15:35:02 GMT

I am looking to use a dimension 'UnitOfMeasore' and place it next to multiple expressions to show what UOM is being used in each case. What would be the best way to go about this?

Re: Calculated/Conditional Dimension Question

Gysbert_Wassenaar — Tue, 15 Mar 2016 16:19:17 GMT

Try it out in a straight table and see if you get the results you expect.

Re: Calculated/Conditional Dimension Question

joe_mccorkel — Tue, 15 Mar 2016 16:25:52 GMT

It is currently in a straight table. Here is probably a better example of what I am looking to do. There are five expressions that total different amounts. I am looking to put a dimensions that shows the UOM next to each of these. There is not a separate UOM field in the tables for each expression, and only one that exists.

Re: Calculated/Conditional Dimension Question

Gysbert_Wassenaar — Tue, 15 Mar 2016 16:46:16 GMT

So, you don't have a field UnitOfMeasore in your data. Then you'll have to create it. How is it calculated?

Re: Calculated/Conditional Dimension Question

joe_mccorkel — Tue, 15 Mar 2016 16:49:36 GMT

There is a field for UnitOfMeasure, just not for these individual fields that we are summing.

Here would be a column list example:

FieldA | UOM | FieldB | UOM | etc

The UOM may be different for each summed field, which is where I think I am most unsure of how to display

Re: Calculated/Conditional Dimension Question

Gysbert_Wassenaar — Wed, 16 Mar 2016 06:22:08 GMT

This is getting more and more confusing instead of less. Please post a small example qlikview document with data that demonstrates the problem.

Re: Calculated/Conditional Dimension Question

Kushal_Chawda — Wed, 16 Mar 2016 06:32:06 GMT

Please create the Sample data and draw how output should look like so that it will be more clear to all