Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi im having trouble getting a dynamic lable to work in a qliksense app.
I want to name a lable based on two selections.
first is an id and second is a value stateing the type of field. the id is selected from a box while the field_name is the one which will change and can be many different values.
below is the metatable containing the lable names. field_desc is the lable name and field_name is the type. and ctrl_id is the id.
I try using code like =If(GetFieldSelections(field_name) = 'T_AMT', field_desc) but the lable turn out as - instead of "TAP CHARED MIN"
I think I have approached something similar with the below formula:
=If(GetFieldSelections(field_name) = 'T_AMT', concat(distinct field_desc))
thanks for the suggestion, unfortunately it didnt work for this problem. the problem is because there is two values available with the selection both the value of R_AMT and T_AMT.
If the problem was in SQL i need what would translate to select field_desc where field_name = 'T_AMT' and ctrl_id = Selectedvalue() if that makes sense.
If there is a selection in both ctrl_id and field_name, can your expression just be:
=field_desc
-Rob
field_name needs to be unselected, since in the chart different dimensions will need different names so a chart will at the same time show one dimension with like in the picture field_name t_amt and another with field_name r_amt and then another name. the idea is for field_desc to change value dependend on the selected id (ctrl_id)
I think I understand now. You want
Only({<field_name{'T_AMT'}>}field_desc)
-Rob