topic Re: GetCurrentField() without IF statement in QlikView

GetCurrentField() without IF statement

Tue, 04 Jun 2013 14:40:59 GMT

Is it not possible to use GetCurrentField directly in an expression without using it in an IF statement like so:

Count(=GetCurrentField(CustomerTopTenCycle))

Re: GetCurrentField() without IF statement

alexandros17 — Tue, 04 Jun 2013 14:46:13 GMT

getcurrentfield return a value so you can use it in an expression ...

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 14:51:20 GMT

I'm not having any luck doing so. This is my actual expression:

Count(TOTAL {<[Fiscal Year]={'2012'}>} GetCurrentField(CustomerTopTenCycle))

If I replace the GetCurrentField function with the actual field name, it returns 35 which is correct, with the function in place, it only returns 1 for each row.

Re: GetCurrentField() without IF statement

alexandros17 — Tue, 04 Jun 2013 14:55:41 GMT

Yes, it's a value not a reference to a field but if your field name is myField you can

Count(TOTAL {<[Fiscal Year]={'2012'}, myField={'$(=GetCurrentField(CustomerTopTenCycle))'}>} myField)

let me know

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 15:24:07 GMT

"myField" is what is in question, as "myField" is determined by which field in the cycle is selected. Maybe I'm misunderstanding?

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 15:40:02 GMT

Count(TOTAL {<[Fiscal Year]={'2012'}>} $(=GetCurrentField(CustomerTopTenCycle)))

Working ?

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 15:45:19 GMT

Thanks for the reply yadurand, but no, that doesn't work. It returns nothing with that syntax.

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 15:56:20 GMT

Strange

I reproduced your fields and group names in a qvw and what i pasted is working for me

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 16:18:14 GMT

Yeah, something isn't right on my end. I've tried two other cycle groups and get a result (35), but it stays the same for every field in the cycle on each group. I'm not sure if it's a Qlikview glitch, or if I'm missing something. I'll continue to investigate and update you. Thanks for your continued help.

Re: GetCurrentField() without IF statement

Tue, 04 Jun 2013 20:17:01 GMT

I never did get this to work correctly. It would work with some fields in the group and not others and I couldn't determine why. I eventually went with an IF statement which didn't seem to have any real performance hit.

If(

GetCurrentField(Mon_Terr_CatSubSect_Cycle)='Ship To',

Count(TOTAL DISTINCT {1<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}>} [Ship To])

If(

GetCurrentField(Mon_Terr_CatSubSect_Cycle)='Territory',

Count(TOTAL DISTINCT {1<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}>} Territory)

If(

GetCurrentField(Mon_Terr_CatSubSect_Cycle)='Month',

Count(TOTAL DISTINCT {1<[Fiscal Year]={'$(FiscalCurrentYear)'},[Sales Amount]={'>0'}>} Month)

If(

GetCurrentField(Mon_Terr_CatSubSect_Cycle)='Sales Catalog Sub Section',

Count(TOTAL DISTINCT {1<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}>} [Sales Catalog Sub Section])

))))

Thanks again for the suggestion.

Re: GetCurrentField() without IF statement

agigliotti — Tue, 04 Mar 2014 14:01:13 GMT

Did you find a solution ?

I have to use something like this:

Sum( {< [Field1] = >} TOTAL <[$(=GetCurrentField(<ProductCycle))]> [LF Amount] )

in one expression with a cyclic group as dimension.

Many Thanks.

Regards

Re: GetCurrentField() without IF statement

agigliotti — Tue, 04 Mar 2014 14:18:08 GMT

I solved, take a look here:

Re: GetCurrentField use in cyclic group

Re: GetCurrentField() without IF statement

Tue, 10 Jun 2014 13:16:45 GMT

I apologize that I did not see this reply Andrea. Thank you for taking the time. I'm glad you got it solved.