Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please check
GETCURRENTFIELD(),
e.g. IF(GETCURRENTFIELD(SalesForecast) = 'HF', SUM(Sales), COUNT(Sales))
HTH Peter
edit: apostrophs added
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.
Are you looking for something like this
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.
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.
-------
Hello,
honestly, it is very difficult for a beginner like me.
Do you any alternative idea?
Thank you.
Alâa Eddine.
Nothing I can think of.
Can you post your sample file? I'll see if I can help.
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