Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Where Clause for a Table chart?

Ok so I would like to create a straight table chart with, let's say, 10 fields.  but I only ever want to show the records where one of the fields has a specified value (ex: dob>1/1/2000).  I don't want to have a filter on that field, I only ever want that data shown in that specific table chart.  
 
I have done this with bar charts and the like, but the "where clause" is usually in the calculated measure.  There is no measure in the table chart, only dimensions. I've tried using a calculated dimension similarly, but it does not work.  
 
I also can't do this in the data load as it would exclude information that I would need for other charts. 


1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Where Clause for a Table chart?

So it's not exactly what I was trying to do, but I ended up using an "action" on the sheet to force the value of that field to filter down to what I wanted.  So any time the sheet is entered, the filter is forced on.  I then did the opposite on the other sheets to force that filter off when those sheets are entered.

bit of a work around I guess, but it did what I needed

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Re: Where Clause for a Table chart?

When you drop the table onto the sheet, you can add both dimensions and measures.

table.PNG

 

You could use an "If" statement in the column like,

 

If(dob > '1/1/2000',dob,Null())

and suppress nulls on that column.

 

Highlighted
Contributor III
Contributor III

Re: Where Clause for a Table chart?

So it's not exactly what I was trying to do, but I ended up using an "action" on the sheet to force the value of that field to filter down to what I wanted.  So any time the sheet is entered, the filter is forced on.  I then did the opposite on the other sheets to force that filter off when those sheets are entered.

bit of a work around I guess, but it did what I needed

View solution in original post