How to use set analysis in Dimension?

[hemanthaanichet]

Hi QV Guys,

is there any possible ways to use a set analysis in dimension?

Regards

Hemanth

[devarasu07]

Hi Hemanth,

Yes,

example,

=aggr(rank(sum({<StoreName=,MaterialHuddleGrpDesc={'SLG'}>} SoldQty)),ArticleNo)

share your requirement/ sample app then it's easy us to help you. tks

[amit_saini]

Hi Hemanth,

In general you have to use Aggr() function ,something like below:

=Aggr( Only({<Plant=,ID=>} ID), ID)

But would be great if you can share your requirement.

Thanks,

AS

[Anonymous]

Hi Hemanth,

Yes you can use set analysis in dimension as add calculated dimension with aggregate (aggr()) function.

Thanks,

Pooja

[hemanthaanichet]

Hi Deva,

i think u said to in expression.

i need a requirement that is i need to use a set analysis in calculated dimension which would apper as dimension

[devarasu07]

Hi Hemanth,

Please refer the sample app  (refer last sunny reply with calculatd dimension)

ABC AABC Analysis in Qlikview

Thanks, deva

[#7]

Hi Hermanth

Please see attached example. (Just a quick one)

If we know your exact requirement we can assist you better.

Kind Regards

[Anonymous]

Hi,

I have a similar requirement, and I tried writing an expression analogous to your solution:

aggr(Only({<Month=,Month_date=,[Media Coverage]={'Yes'}>}[Description of the Incident]),[Description of the Incident])

but the data still changes with the month filter. Any suggestions on how to make Month inactive here?