New to Qlik Sense

[abhirup]

I have a QlikSense Table chart with only dimension columns REGION and PRODUCT. My use case is, the "Time Period" filter selections should not impact the table chart with dimensions. i.e. the table should display all values of REGION and PRODUCT even if the "Time Period" filter is selected.

Raw Data

Region	Product	Time Period
RA	Box	Jan'20
RA	CD	Feb'20
RC	Mobile
RD	Box	Feb'20

In Qlik Sense even if Time Period = Feb’20 filter is selected all the values of Region and Product should be displayed in the table chart as below. So how should the below dimension expression be written?

Region	Product
RA	Box
RA	CD
RC	Mobile
RD	Box

[tresesco]

As an alternate solution (though not very neat), you could use a dummy expression like =Avg({1} 1) and hide in UI (resizing)

[abhirup]

Can you please explain how do we "hide in UI (resizing)"?

The table chart only has conditional column hiding, which doesn't work if I hide the dummy measure "=Avg({1} 1)".

[tresesco]

When you are in the UI and out of 'Edit' mode, if you hover mouse over the column (header; check the bold border in the screen shot below), you would be able to drag and pull right to hide it.

[abhirup]

Thanks for the suggestion.

But that doesn't work as it is visible as you increase the chart to full screen or change the screen resolution size.

So this solution doesn't work.

Anyone has a different solution for this problem statement?

  @Kushal_Chawda   @lorenzoconforti 

[lorenzoconforti]

If you don't want to include a measure, the only other solution I can think of is to have the table and the filter on two different alternate states

If you then need to use the time period selection in any of the visualisations, you can just reference that alternate state through set analysis