Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using qlik sense desktop.
I have a script to load data from an excel file.
My table:
Project | Value |
---|---|
A | 10 |
B | 5 |
C | 7 |
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.
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
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.
Hi,
Try to use set analysis like this
sum({<Value={">5"}>}Value)
Sorry for my ignorance, what is set analysis in qlik sense?
Hi,
PFA. Hope this helps to you
Set analysis:
Aggregation functions normally aggregate over the set of
possible records defined by the current selection