topic Re: 'GetCurrentField' Function not working with expression in QlikView

'GetCurrentField' Function not working with expression

ektarathi — Fri, 26 Jan 2018 18:58:48 GMT

Hi All,

I have created a Cyclic group named 'Period' and I have added three expressions to it to show Monthly, Quarterly and Annual data.

I have used this group on a bar graph, and I want bar graph title to change as per group selected. I use 'GetCurrentFiled' function whenever I want to find what value is selected in a group. But when I do it for this expression, I get error "Error: Error in Expression : ')' expected'. Can someone please help me with this. I am on QV 11 version.

Below is an example of what I am trying to do.

Cyclic group name : Period

First expression for group name Period : =date(If(MONTH_END_DT=InputDateVar or MONTH_END_DT=MnthVar1 or MONTH_END_DT=MnthVar2
or MONTH_END_DT=MnthVar3 or MONTH_END_DT=MnthVar4 or MONTH_END_DT=MnthVar5 or MONTH_END_DT=MnthVar6 or MONTH_END_DT=MnthVar7 or MONTH_END_DT=MnthVar8 or
MONTH_END_DT=MnthVar9 or MONTH_END_DT=MnthVar10 or
MONTH_END_DT=MnthVar11 or MONTH_END_DT=MnthVar12,MONTH_END_DT),'MMM yyyy')

Expression I used in bar graph to get correct Title :--

=If(GetCurrentField([Period])='=date(If(MONTH_END_DT=InputDateVar or MONTH_END_DT=MnthVar1 or MONTH_END_DT=MnthVar2
or MONTH_END_DT=MnthVar3 or MONTH_END_DT=MnthVar4 or MONTH_END_DT=MnthVar5 or MONTH_END_DT=MnthVar6 or MONTH_END_DT=MnthVar7 or MONTH_END_DT=MnthVar8 or
MONTH_END_DT=MnthVar9 or MONTH_END_DT=MnthVar10 or
MONTH_END_DT=MnthVar11 or MONTH_END_DT=MnthVar12,MONTH_END_DT),'MMM yyyy')', 'Monthly Graph')

Re: 'GetCurrentField' Function not working with expression

ektarathi — Mon, 29 Jan 2018 17:51:42 GMT

Hi All,

Any thoughts on this?

Thanks!

Re: 'GetCurrentField' Function not working with expression

Anil_Babu_Samineni — Tue, 30 Jan 2018 00:34:54 GMT

Try to share sample?

Re: 'GetCurrentField' Function not working with expression

vishsaggi — Tue, 30 Jan 2018 03:25:12 GMT

May be try this?

=If(GetCurrentField([Period])= date(If(Match(MONTH_END_DT, $(InputDateVar),

$(MnthVar1),

$(MnthVar2),

$(MnthVar3),

$(MnthVar4),

$(MnthVar5),

$(MnthVar6),

$(MnthVar7),

$(MnthVar8),

$(MnthVar9),

$(MnthVar10),

$(MnthVar11),

$(MnthVar12)), MONTH_END_DT),'MMM yyyy'), 'Monthly Graph')

Ignore above and why don't you just use the below expression in your Chart

= $(=GetCurrentField([Period]))

Try this and switch the cyclic expressions you created.

Refer this too, might be helpful.

How to get the used expression?