Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francisco_cohen
New Contributor III

Filter a table

Hi,

I'm using qlik sense desktop.

I have a script to load data from an excel file.

My table:

ProjectValue

A10
B5
C7

then, in my visualization (myfilter), I have a table and a dimension with the expression:

if(value>5,'Show')

I would like to use this dimension to filter my table by default without the user having to select "Show" from a filter pane.

How can I  do this?

Thank you for your time.

FC.

5 Replies
vvira1316
Valued Contributor II

Re: Filter a table

Hi,

you can restrict at the time of load by following

LOAD

    Project,

    Value

FROM [lib://DataConnector/YourDataFile.xlsx]

(ooxml, embedded labels, table is Sheet1)

where Value > 5;

Or if it is a measure in the chart table then in the expression you can restrict it.

Both this way user will not see records you don't want them to see

francisco_cohen
New Contributor III

Re: Filter a table

Hi,

Thank you for your time.

I prefer to solve it in the table instead of in the script.

How can I do that? I have a measure added to my table but I get it in a column.

I want the table to be filtered by the measure, not the user filtering.

devarasu07
Honored Contributor II

Re: Filter a table

Hi,

Try to use set analysis like this

sum({<Value={">5"}>}Value)

Capture.JPG

francisco_cohen
New Contributor III

Re: Filter a table

Sorry for my ignorance, what is set analysis in qlik sense?

devarasu07
Honored Contributor II

Re: Filter a table

Hi,


PFA. Hope this helps to you

Set analysis:

Aggregation functions normally aggregate over the set of

possible records defined by the current selection