Filtering a table in QSense

[#1]

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

[beck_bakytbek]

Hi Dolve,

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

i hope that help

Beck

[#3]

Hi Beck

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

[Anonymous · Accepted solution]

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)

[#5]

Wow, thank you very much!

I was struggling with that so long.

Thanks!

[Anonymous]

No problem

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