Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
meetmrudul
Contributor II

GetCurrentField in Set Analysis

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,

MK

9 Replies

Re: GetCurrentField in Set Analysis

try with

sum({ $ <cycle1=>}vol)

meetmrudul
Contributor II

Re: GetCurrentField in Set Analysis

nope, doesn't work...

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

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

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

nothing work....

rgvavihs
Valued Contributor

Re: GetCurrentField in Set Analysis

Hi

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

meetmrudul
Contributor II

Re: GetCurrentField in Set Analysis

can you please provide link for same...

rgvavihs
Valued Contributor

Re: GetCurrentField in Set Analysis

Hi

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
New Contributor II

Re: GetCurrentField in Set Analysis

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

Re: GetCurrentField in Set Analysis

try,

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

where vExclude = getcurrentfield([YourCyclicGroupName])

rgvavihs
Valued Contributor

Re: GetCurrentField in Set Analysis

This might work

Digvijay_Singh
Honored Contributor III

Re: GetCurrentField in Set Analysis

Try this(replace group field with yours) -

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