Adjusting formula to the cyclic group

[Anonymous]

Hello,

please find the capture below:

As you can see here i have two axis and a cyclic group that contains "HF", "Aggr Brand", ...etc. The problem is the formula of volatility presented in horizontal axis should change according to the choice that we do in the cyclic group: for example if i choose HF as the capture, i want the expression of the volatility will be adjusted to HF and if i choose Aggr Brand i want the formula of the volatility will be adjusted to Aggr Brand.

In other terms,  i want to translate this formula in QlikView language:

                if(cyclic group = HF, volatility_expression_HF, if(cyclic group=Aggr Brand, volatility_expression_Aggr Brand).

The cyclic group is called: Sales Forecast if this information is beneficial.

Thank you very much

Best ragards,

Alâa Eddine.

[prieper]

Please check

GETCURRENTFIELD(),

e.g. IF(GETCURRENTFIELD(SalesForecast) = 'HF', SUM(Sales), COUNT(Sales))

HTH Peter

edit: apostrophs added

[Anonymous]

Hello,

i tried but i do not know why the name od the cycliv group was underlined with red line.

                        Do you have any ideas?

Thank you.

I really need this will be solved.

Best regards,

Alâa Eddine.

[Anonymous]

Hello,

i tried but i do not know why the name od the cycliv group was underlined with red line.

                      

To be sure the formula is:

if(getcurrentfield(group_name)='HF', expression) Right??

Do you have any ideas?

Thank you.

I really need this will be solved.

Best regards,

Alâa Eddine.

[vamsee]

Are you looking for something like this

Set the active field in a cyclic group.qvw

[Anonymous]

Hello,

thank you but i cannot open the file. Can you just tell me the formula that i have to use or a  document that can help me?

Thank you,

Alâa Eddine.

[vamsee]

Okay. The steps in the document are

Steps:

1.Create Variables

  vUserFieldValueRename = PICK(MATCH(USERNAME,'HCP_FULL_NAME','SALESREP_FULL_NAME'),'HCP','SALESREP') and

  vUser = GetFieldSelections(USERNAME).

2.Create a list box (see list box with no caption) with  field as expression with    =$(=vUserFiledValueRename)

3.Create a list box (see list box with caption) with  field as expression with      =$(='['& only($(=vUser)) & ']')

4. By following the above steps, we can achieve the following:

   a.Rename field values (values in the list box with no caption have been renamed)

   b.A field name can be selected in one list box which in turn populates the field in another list box.

   c.Caption changes according to the selections made in the 1st list box.

-------

Credits Set the active field in a cyclic group.qvw

[Anonymous]

Hello,

honestly, it is very difficult for a beginner like me.

Do you any alternative idea?

Thank you.

Alâa Eddine.

[vamsee]

Nothing I can think of.

Can you post your sample file? I'll see if I can help.

[prieper]

Dear,

The groupname used by you includes blanks.

Please enclose in square brackets. Thus

IF(GETCURRENTFIELD([Sales Forecast]) = 'HF', ..... etc

should do the trick.

There might be a bug in the interpreter, as also this expression will show the red line below.

When you develop functions, it might be easer, first to check on the kernel of the function before nesting.

Having said: Create a Textbox and enter

=GETCURRENTFIELD([Sales Forecast])

and see, if the output is as expected.

HTH

Peter