topic Re: Condition on group field name in QlikView

Condition on group field name

agni_gold — Mon, 26 Jun 2017 01:14:57 GMT

Hi Friends,

I have one cyclic group in which I have created one calculated dimension like

=CalendarMonthName& - &%Year and Label its as Month

Now when I am applying condition on my cyclic group which is <cyclYM

it is not working

=if(GetCurrentField("<cyclYM")='=CalendarMonthName& - &%Year ',1,0)

Re: Condition on group field name

Anil_Babu_Samineni — Mon, 26 Jun 2017 01:26:06 GMT

Use, Something like below in synthetically

I would ask you create in script

CalendarMonthName& - &%Year as FieldName

Try this?

=if(GetCurrentField([cyclYM]) = FieldName, 1,0)

Re: Condition on group field name

agni_gold — Mon, 26 Jun 2017 01:28:42 GMT

Thanks, but in script level, it is not supposed to done .

Any alternative in front end ?

Re: Condition on group field name

Anil_Babu_Samineni — Mon, 26 Jun 2017 01:31:17 GMT

My recommend always in Back end only. If you want to forcibly to do in front end. I would ask to share sample application that demonstrates the issue?

Re: Condition on group field name

agni_gold — Mon, 26 Jun 2017 01:36:57 GMT

here it is

Re: Condition on group field name

Anil_Babu_Samineni — Mon, 26 Jun 2017 02:01:07 GMT

Can i know the reason why you don't want to do in Script because i felt it is very bad in Front end. Even you are using simple Year and Month only why can't club or create composite key and uses rather than complex. Still you need i recommend him mrkachhiaimp‌

Re: Condition on group field name

agni_gold — Mon, 26 Jun 2017 02:03:52 GMT

This is just a mock application , but in my actual application Year and Month fields are used from different tables.

Re: Condition on group field name

agni_gold — Mon, 26 Jun 2017 02:04:29 GMT

swuehl‌ can it be possible?

Re: Condition on group field name

swuehl — Mon, 26 Jun 2017 08:13:26 GMT

The single quotes in your calculated dimension interfere with your expression to check current dimension, for example, you can try to replace them:

=if(Replace(GetCurrentField("<cyclYM"),chr(39),'|')='=YearOrg&| - |&%Month',1,0)

Re: Condition on group field name

agni_gold — Mon, 26 Jun 2017 16:35:23 GMT

You are so awesome man great !

Thanks