topic Re: distinct field values in dimension tab in QlikView

distinct field values in dimension tab

Tue, 08 Nov 2011 08:36:48 GMT

Hi all,

I need to display only distinct fields in the dimension tab of Straight table. All the dimensions should display only distinct field values.

See below image, for AnchorIndex field is having repeated values, how to avoid this.

how is this possible ?

Thanks in advance

Regards

Venkat

distinct field values in dimension tab

SunilChauhan — Tue, 08 Nov 2011 08:44:04 GMT

use num(trim(AnchorIndex)) in dimension and give the label as AnchorIndex

hope this help

distinct field values in dimension tab

jagan — Tue, 08 Nov 2011 08:49:00 GMT

What are all the dimensions in the straight table other than AnchorIndex? If AddPower is also a dimension, does one AnchorIndex have multiple AddPowers?

Re: distinct field values in dimension tab

Tue, 08 Nov 2011 09:02:53 GMT

Hi,

All the fields in the image are dimensions.

All the fields will have a relation with other fields.

Regards

Venkat

distinct field values in dimension tab

jagan — Tue, 08 Nov 2011 10:55:38 GMT

Why don't you use Pivot table instead of Straight table? It will group the values and show you a single value.

Regards,

Jagan.

Re: distinct field values in dimension tab

Tue, 08 Nov 2011 11:00:50 GMT

I need to export data into a Tab delimited text file. And the major requirement is also display the data in straight table.

Regards

Venkat

Re: distinct field values in dimension tab

Wed, 26 Jun 2013 15:44:42 GMT

I am currently trying to do a very similar thing. Any luck using distinct values for a dimension?

Re: distinct field values in dimension tab

Wed, 26 Jun 2013 15:56:13 GMT

HI ,

I think you need to use some Aggregate function in the expression .

Regards

Yusuf