topic Re: GetCurrentField in Set Analysis in QlikView

GetCurrentField in Set Analysis

Anonymous — Wed, 02 Sep 2015 12:30:29 GMT

Hi All,

We have a requirement, where in the expression, we have to ignore the dimension in the cyclic group in set analysis expression.

Suppose, the expression is sum({<dim1=>}vol), where the dim1 is present in cycle1.

So, we need something like -

sum({<GetCurrentField([cycle1])=>}vol)

We need it as there are around 6 dimensions, can anyone pls suggest.

Thanks & Regards,

alexandros17 — Wed, 02 Sep 2015 12:34:43 GMT

try with

sum({ $ <cycle1=>}vol)

Anonymous — Wed, 02 Sep 2015 12:38:01 GMT

nope, doesn't work...

I tried sum({ $ <cycle1=>}vol)

sum({ $ <[cycle1]=>}vol)

sum({ $ <(cycle1)=>}vol)

nothing work....

Anonymous — Wed, 02 Sep 2015 12:39:21 GMT

Try with '$' sign in set analysis as suggested by Alexandros17

Anonymous — Wed, 02 Sep 2015 12:44:55 GMT

can you please provide link for same...

Anonymous — Wed, 02 Sep 2015 12:53:54 GMT

Can you share sample application.

And you want to ignore dimensions in cyclic group ???

Your requirement is unclear for me .Can you please elaborate

Thanks

sauliusr — Wed, 02 Sep 2015 12:58:46 GMT

sum({<[$(=GetCurrentField([cycle1]))]>}vol)

Kushal_Chawda — Wed, 02 Sep 2015 13:04:05 GMT

try,

=sum({<$(vExclude)>}Sales2)

where vExclude = getcurrentfield([YourCyclicGroupName])

Anonymous — Wed, 02 Sep 2015 13:07:05 GMT

This might work

Digvijay_Singh — Wed, 02 Sep 2015 13:40:09 GMT

Try this(replace group field with yours) -

=Sum({<$(=GetCurrentField(Year_Month))=>}Sales)