topic Calculated Dimension: first value in QlikView

Calculated Dimension: first value

Tue, 11 Aug 2009 21:26:27 GMT

Hi guys,

I'm not sure what the best way to do this is. I'm creating a pivot table which displays information on certain orders. For one of the dimensions I'm displaying, I only want the first value that comes up. I've used firstsortedvalue before, but in this case I don't actually want to sort them by anything, I just want the first record that is stored for that field. I tried using the First() function but I got the "//error in calculation" message displayed in the table.

I also tried creating an entirely new field on the data import using the firstvalue command but that also seemed to cause a problem. Any ideas?

Dan

Calculated Dimension: first value

stephencredmond — Tue, 11 Aug 2009 21:37:18 GMT

Hi Dan,

If you use a set - perhaps using FirstSortedValue - in your expression then the other values will be zeroed and suppressed by default.

Regards,

Stephen

Calculated Dimension: first value

Tue, 11 Aug 2009 21:46:34 GMT

Hey Stephen,

can you elaborate on this? I'm not sure what you mean.

Dan

Calculated Dimension: first value

stephencredmond — Tue, 11 Aug 2009 21:56:55 GMT

Hi,

If I have a dimension, say it is called "MyDimension", that has 3 values - A, B, C. If I want to show a chart that has only results from Value = A, I can do that by putting a set in my expression:


 sum( { < MyDimension = {A} > } Sales )

Now the chart will not display B or C because one of the default options in the presentation tab is to suppress zero results.

Regards,

Stephen

Calculated Dimension: first value

Tue, 11 Aug 2009 22:17:26 GMT

ah I see. Interesting functionality but not something that I can use. This field contains a set of entries for each order which aren't necessarily the same for each order. Creating a set would possibly eliminate correct values for other orders.

Calculated Dimension: first value

Wed, 12 Aug 2009 00:16:05 GMT

is there a way to enforce that a field only contains a single value?