If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have four tables and I have the same field in these 4 tables with different contents. How can I use the same named field in these tables only in a filter?
@krmvacar You can concatenate all the 4 tables. And then you can use that particular field which ever you wanted to use it in the Filter.
yes I know this way. Is there any other way you would suggest? Thanks for your help
Can you elaborate further what you exactly need, may be by some sample and expected output.
There could be 2 cases you are asking
1.If Key is Same and rest content is different in 4 tables then-
You can Directly associate your 4 tables on the basis of that Key field(i.e. without any join or keep in between the tables and just aliasing Key field all 4 tables) and then take a filter box at the frontend of that key field which will contain all values from all 4 tables.
2. Other Case is explained by- @sidhiq91
I have tables and I have linked these tables with a common field. All my tables have the same field REPORTNAME name of this field. And I want to use this field in a single filter. When I turn on the filter, it only shows me a filter in a table.
When I put it as a filter, I will be able to filter it according to the report type I choose.
First table My fıeld Report name: a,b,c
Second table My fıeld Report name : d,e,f
Hi @Manish_Kumar_ As u said in your first point, if u will simply let each table join without any join and keep there will be Synthetic keys or Circular Loop will be generated if there is a single distinct field which I guess will not provide the correct output.
Hi @krmvacar As others suggested, u can concatenate your tables. But before that give a flag to each table, which will identify each table in filter instead of having same field names.
HI @Shriya Let me explain to you my point again
I Specifically mentioned the case that One can associate tables on the basis of a key field, "while the rest other fields are different i.e. differently named". So then only we can leave the 4 tables on a linking basis without any joins
This is the first case
But if the requirement is to append the fields then Concatenating is perfect!
Hope all things are clear!!