Filter selection is leading to vanishing of data from sheet

[gsmohanty23]

Hi all,

I am new to Qlik Sense. I have a peculiar issue with my QlikSense sheet. 

I have concatenated 2 tables and created a Vizlib filter. When I select values from the filter the data from the first table gets filtered as expected. But data coming from the second table vanishes from the sheet.

The tables are concatenated and Autonumber is used on the Date Key, to resolve the synthetic key issue. Please let me know how to resolve this.

[anat]

do you have set of data from the second table for the filtered value?

can you share the logic in 2nd table as well data model how the tables are linked

[gsmohanty23]

Hi Anat,

Thank you for replying.

Yes, to your first question

I will not be able to share as it has confidential data. I will try to explain

For example Table 1 and Table 2 :

First Table 1 is loaded, in which the Date field is updated using Autonumber().

Then Table 2 is loaded, here also the Date field is updated using Autonumber()

Then both the tables are concatenated. When I see the Date fields of both the tables, the Date key is sequential as shown below.

Table 1 | Table 2 

1.                 -

2.                 -

3.                 -

4.                 -

  -           5

  -           6

   -          7

    -         8

So I think the tables are linked using Date key.

[anat]

seems your tables are not linked , concatenate 2 tables without autonumber then see the data

[gsmohanty23]

Will it not create Synthetic Keys? I thought Autonumber() improves the performance of the report. Is there a way to link tables with Autonumber()?