Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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;
Hello Vincent,
Thank you for your response. I will try to implement this and check.