Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhirup
Contributor II
Contributor II

Ignoring Filters in table chart with only dimension columns

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

RegionProductTime Period
RABoxJan'20
RACDFeb'20
RCMobile 
RDBox

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?

RegionProduct
RABox
RACD
RCMobile
RDBox
5 Replies
tresesco
MVP
MVP

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

abhirup
Contributor II
Contributor II
Author

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

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.

Untitled.png

abhirup
Contributor II
Contributor II
Author

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
Specialist II
Specialist II

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