Qliksense Same field One filter

[krmvacar]

Hİ @all

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?

Best Regards.

[sidhiq91]

@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.

[krmvacar]

Hi @sidhiq91 

yes I know this way. Is there any other way you would suggest?  Thanks for your help

[Digvijay_Singh]

Can you elaborate further what you exactly need, may be by some sample and expected output.

[Manish_Kumar_]

Hi @krmvacar 

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 

[krmvacar]

Hi @Digvijay_Singh  

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.

Example:

First table  My fıeld Report name: a,b,c

Second table My fıeld Report name : d,e,f

Qualify *;
Unqualify 'KEYFLD*';

Best Regards

[Shriya]

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.

[Shriya]

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.

[Manish_Kumar_]

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!!