topic Re: Get field names from groups to change Variance column in QlikView

Get field names from groups to change Variance column

adurgani — Mon, 07 May 2018 15:17:45 GMT

IN the attached image, I have two grouped columns and the third column is a variance. I would like to change the name of the column dynamically based on what is selected in the group?

In the image, the variance column should say VAR ('June Forecast' - 'April Forecast') my formula is using the column(2) - Column(1) to calculate variance.

If the user changes his selection and changes column (1) to budget, the variance column should say VAR ('June Forecast' - 'Budget')

Re: Get field names from groups to change Variance column

jaumecf23 — Mon, 07 May 2018 15:28:39 GMT

Try this:

GetCurrentField("Name_of_the_Group")

Re: Get field names from groups to change Variance column

Anil_Babu_Samineni — Mon, 07 May 2018 15:30:28 GMT

Really tough to explain in each Group level. Perhaps this for Label?

Pick(Match(GetCurrentField('Cyclic Group Name')+1, 'Normal', 'variance column'), 'Budget', 'June Forecast - Budget')

Re: Get field names from groups to change Variance column

adurgani — Mon, 07 May 2018 15:32:24 GMT

How do I find the name of the group?

Re: Get field names from groups to change Variance column

adurgani — Mon, 07 May 2018 17:42:40 GMT

The issue is it's not a cyclic group but an expression group. I cant seem to find anyone that has solved it in a way that a newbie like me can understand.

Re: Get field names from groups to change Variance column

Anil_Babu_Samineni — Tue, 08 May 2018 00:28:10 GMT

Just for idea - You can give direct Label as dynamic to change when you select something like. Can you provide mock up and explain the outcome?

=If(FieldName = 'Selector', 'Budget', 'Normal')

Re: Get field names from groups to change Variance column

adurgani — Tue, 08 May 2018 15:01:42 GMT

Attached an example to my original post. Let me know if there are any questions.

I want the variance column label to change dynamically based on the expressions names in column 1 and column 2

Thanks Anil!

Re: Get field names from groups to change Variance column

Anil_Babu_Samineni — Tue, 08 May 2018 15:28:13 GMT

Interesting, Not entirely sure about investigation. Might be marcus_sommer‌

Re: Get field names from groups to change Variance column

marcus_sommer — Tue, 08 May 2018 16:44:11 GMT

AFAIK there is no way to get the name/content of the active expression in an expression-group (maybe per macros but their use isn't recommended within the UI and it would be also not trivial to build such a routine).

This meant you need a different approach. This could be to convert the expression-groups into dimension-groups to be able to use getcurrentfield() or an outside control which expressions are displayed - per variables or probably better per field-selections. An example of it s in the Qlik Demo "What's new" and there are also multiple examples in the community: https://community.qlik.com/search.jspa?q=dynamic+charts&type=document.

- Marcus