topic Re: Avoiding Quality field names with table name in front end selection in qliksense app in App Development

Avoiding Quality field names with table name in front end selection in qliksense app

SunainaUmberkar — Fri, 17 Nov 2023 13:29:10 GMT

Hello All,

This question is regarding Qualify statement.

In Qualify statement, we always get tablename.fieldname. But can we avoid table name in the front end when we make selection? So that only fieldname is displayed in the selection.

I know the best way is to either rename the fields or concatenate and create a flag and use flag in front end. But if we don't want to do above both then basically Qualify statement is the option. But selection is an issue, is there a way to avoid it?

Thanks is advance.

Re: Avoiding Quality field names with table name in front end selection in qliksense app

whiteymcaces — Fri, 17 Nov 2023 14:10:49 GMT

I have been working with Qlik Apps for over 15 years and I have never used the Qualify Statement. I make sure I take the time to rename all the fields, that will be seen in the front end, within the script. Only fields that are seen in charts or that users make selections on.

Re: Avoiding Quality field names with table name in front end selection in qliksense app

vincent_ardiet_ — Fri, 17 Nov 2023 15:10:23 GMT

You can do a massive renaming, this will not rename fields which could suddenly have the same name or those without the dot. You can make it better to avoid fields containing specific chars or names.

For t = 0 to NoOfTables() - 1
mapRename:
Mapping Load
FieldName(RowNo(),TableName($(t))) as FieldName,
SubField(FieldName(RowNo(),TableName($(t))),'.',2) as NewFieldName
AutoGenerate NoOfFields(TableName($(t)));
Next t;
Rename Fields Using mapRename;

Re: Avoiding Quality field names with table name in front end selection in qliksense app

SunainaUmberkar — Wed, 22 Nov 2023 08:46:14 GMT

Hello Vincent,

Thank you for your response. I will try to implement this and check.