Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Better way to aggregate fields in a dimension

Hi averyone,

I currently use this calculated dimension:

=if(organization='ABC', Client, organization)

The reason is that I need to set the clients in the organization "ABC" as organizations themselves.

Can i do that in the script, without putting that calculated dimension in every object?

Also better would be to have to possibility to switch through the two options:

1. ABC organization, clients as clients

2. clients as organizations

Thanks so much!

Matteo

3 Replies
fdelacal
Valued Contributor

Re: Better way to aggregate fields in a dimension

can you add a qvw. ??

Not applicable

Re: Better way to aggregate fields in a dimension

Sorry I can't I am using real corporate data...

I add an excel which explains better (I hope)

fdelacal
Valued Contributor

Re: Better way to aggregate fields in a dimension

I THINK YOU NEED THIS.

SEE ATACH

Community Browser