Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Filtering a table in QSense

Hello everybody

Im totally new to QlikSense and these days Im trying to figure out how to use this fantastic tool.

I created a simple table with one dimension and some measures and tried to filter it by one column's (measure) value.

Basically, I just want the chart to show me only values with percentage greater than X.

For me it sounds basic, but after some searches here i understood that its not that easy to create this kind of filter.

I tried to create an expression with result of 1 or 0 and then hide nulls, but the "show nulls" is available only in dimensions.

Does anyone know if there is a solution for that? or it requires an extension?

Thanks a lot

Dolev

1 Solution

Accepted Solutions
gsmajdor
Contributor

Re: Filtering a table in QSense

You can do it this way:

in dimension:

=if(aggr(YourMeasure, YourDimension)>X,YourDimension,null())

in measue:

=YourMeasure


Then you can manipulate "Include null values" in the dimension field.


e.g.:

code in the dimension field:

=if(aggr(count(SalesID), CategoryName)>2000,CategoryName,null())

code in the measure field:

=count(SalesID)

Capture.JPG

5 Replies
beck_bakytbek
Honored Contributor

Re: Filtering a table in QSense

Hi Dolve,

look at this;like a triggers in Qlik View but in Qlik Sense

i hope that help

Beck

Not applicable

Re: Filtering a table in QSense

Hi Beck

Thanks for the answer, but currently i would prefer a solution that doesnt require an extension, if possible

gsmajdor
Contributor

Re: Filtering a table in QSense

You can do it this way:

in dimension:

=if(aggr(YourMeasure, YourDimension)>X,YourDimension,null())

in measue:

=YourMeasure


Then you can manipulate "Include null values" in the dimension field.


e.g.:

code in the dimension field:

=if(aggr(count(SalesID), CategoryName)>2000,CategoryName,null())

code in the measure field:

=count(SalesID)

Capture.JPG

Not applicable

Re: Filtering a table in QSense

Wow, thank you very much!

I was struggling with that so long.

Thanks!

gsmajdor
Contributor

Re: Filtering a table in QSense

No problem

Unfortunately, QS' syntax is not so intuitive and 'friendly' as we wish..