topic Re: Limiting Dimension in QlikView

Limiting Dimension

Wed, 29 Oct 2014 05:34:13 GMT

Hi All,

I have a field that I would like to use as a dimension, but I do not want to use all the unique values in this field, just some of the values. The values I would like to extract as forming the dimension are based on another column eg if Field A says "Agent", then use the corresponding value in Field B as one of the dimensions, otherwise that Iitem in Field B should not be part of the dimensions.

Is this possible, and if so, any ideas on how I can pull this off?

Thanks

Re: Limiting Dimension

its_anandrjs — Wed, 29 Oct 2014 05:37:31 GMT

Provide any sample file please in any inline table than it will easy to help, or yo can use if conditions in the load script.

Regards

Anand

Re: Limiting Dimension

danieloberbilli — Wed, 29 Oct 2014 05:39:11 GMT

Maybe something like:

load

FieldB as DimensionNew

resident xyz

where FieldA ='Agent'

or FieldA =...

or ....

Re: Limiting Dimension

ecolomer — Wed, 29 Oct 2014 05:39:31 GMT

Can you explain more or upload an data example, please

Re: Limiting Dimension

Wed, 29 Oct 2014 05:50:34 GMT

Something like:

if(FieldA='Agent' and Match(FieldB,'Agent'),FieldA, FieldB)

Thanks,

Singh

Re: Limiting Dimension

jonathandienst — Wed, 29 Oct 2014 06:24:40 GMT

Use the following as a calculated dimension:

=Aggr(Only({<FieldA = {'Agent'}>} FieldB), FieldB)

HTH

Jonathan

Re: Limiting Dimension

Wed, 29 Oct 2014 12:07:35 GMT

Thanks Jonathan,

Your answer has provided the closest result. The only snag is that the values that are not "Agent" have been bundled into one line called "-" as a dimension, how do I get rid of this line (straight table) so that I am left with purely the list from Field B that corresponds with "Agent" in Field A.

Otherwise your suggestion is very very close.

Thanks

Re: Limiting Dimension

danieloberbilli — Wed, 29 Oct 2014 12:14:23 GMT

Just check the checkbox Suppress When Value is Null on the dimension tab of the chart properties

Re: Limiting Dimension

Wed, 29 Oct 2014 13:53:55 GMT

Thank you guys