topic Doubt about calculated dimenssion in QlikView

Doubt about calculated dimenssion

Thu, 05 Feb 2015 16:09:30 GMT

Hi i have a list of adress, but i have repeated adress, this is because i have in one adress for example 2 or 3 departments. I wanna separate this adress by departments. For example.

ADRESS DEPARTMENT

Adress 1 -

Adress 2 -

Adress 3 dep A

Adress 3 dep B

Adress 3 dep C

Adress 4 -

Adress 5 -

Adress 6 -

I'm ussing adress of dimmension but my problem is that in the count i have for example in adress 3 count=3, i tried this but it didn't work

=if (COUNT(DISTINCT ADRESS) =1, ADRESS, ADRESS& '-' & DEPARTMENT)

Re: Doubt about calculated dimenssion

Anonymous — Thu, 05 Feb 2015 16:26:56 GMT

HI,

You should create a new filed in the script:

LOAD

....

ADRESS,

ADRESS& '-' & DEPARTMENT as AdressDepartment,

...

FROM

...

Then in the graph, you can count (distinct AdressDepartment)

Re: Doubt about calculated dimenssion

rubenmarin — Thu, 05 Feb 2015 16:29:04 GMT

Hi Jeremias, maybe is better to create the field in script, anyway for calculated dimension:

=Aggr(If(Count(TOTAL <ADRESS> DISTINCT DEPARTMENT)=1, ADRESS, ADRESS& '-' & DEPARTMENT), ADRESS, DEPARTMENT)