Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
hemanthaanichet
Creator III
Creator III

How to use set analysis in Dimension?

Hi QV Guys,

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

Regards

Hemanth

7 Replies
devarasu07
Master II
Master II

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
Master III
Master III

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

singhpooja
Creator III
Creator III

Hi Hemanth,

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

Thanks,

Pooja

hemanthaanichet
Creator III
Creator III
Author

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
Master II
Master II

Hi Hemanth,

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

ABC AABC Analysis in Qlikview

Thanks, deva

Not applicable

Hi Hermanth

Please see attached example. (Just a quick one)

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

Kind Regards

singingplatypus
Partner
Partner

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?