topic Re: How to use set analysis in Dimension? in QlikView

How to use set analysis in Dimension?

hemanthaanichet — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Guys,

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

Regards

Hemanth

Re: How to use set analysis in Dimension?

devarasu07 — Wed, 11 Jan 2017 04:25:14 GMT

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

Re: How to use set analysis in Dimension?

amit_saini — Wed, 11 Jan 2017 04:37:48 GMT

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,

Re: How to use set analysis in Dimension?

Anonymous — Wed, 11 Jan 2017 04:51:04 GMT

Hi Hemanth,

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

Thanks,

Pooja

Re: How to use set analysis in Dimension?

hemanthaanichet — Wed, 11 Jan 2017 04:59:54 GMT

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

Re: How to use set analysis in Dimension?

devarasu07 — Wed, 11 Jan 2017 05:07:26 GMT

Hi Hemanth,

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

ABC AABC Analysis in Qlikview

Thanks, deva

Re: How to use set analysis in Dimension?

Wed, 11 Jan 2017 05:13:09 GMT

Hi Hermanth

Please see attached example. (Just a quick one)

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

Kind Regards

Re: How to use set analysis in Dimension?

Anonymous — Mon, 26 Nov 2018 11:15:50 GMT

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?