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: 
francisco_cohen
Contributor III
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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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

Hi,

Try to use set analysis like this

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

Capture.JPG

francisco_cohen
Contributor III
Contributor III
Author

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

devarasu07
Master II
Master II

Hi,


PFA. Hope this helps to you

Set analysis:

Aggregation functions normally aggregate over the set of

possible records defined by the current selection