Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
joe_mccorkel
New Contributor

Calculated/Conditional Dimension Question

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?

6 Replies
MVP & Luminary
MVP & Luminary

Re: Calculated/Conditional Dimension Question

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


talk is cheap, supply exceeds demand
joe_mccorkel
New Contributor

Re: Calculated/Conditional Dimension Question

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.

MVP & Luminary
MVP & Luminary

Re: Calculated/Conditional Dimension Question

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


talk is cheap, supply exceeds demand
joe_mccorkel
New Contributor

Re: Calculated/Conditional Dimension Question

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

MVP & Luminary
MVP & Luminary

Re: Calculated/Conditional Dimension Question

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


talk is cheap, supply exceeds demand

Re: Calculated/Conditional Dimension Question

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