Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arusanah
Contributor

Filter data based in table on measure

Hi ,

Is it possible to filter Data in table report based on measure value ?

my Requirement is to eliminate rows where sum(M1+M2)=0

   

DimM1m2
AA100344
BB65533
CC333-333
DD44-44
EE2344432
FF323-323
GG3534666

e.g : in above example  I  want to Hide( Dim CC,DD,FF as sum of M1 & M2 =0 for these dim rows.) in my report.

Any help is highly appreciated.

1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Filter data based in table on measure

Make your dimension a calculated one based on your condition you want to excluded

If(AGGR(SUM(M1)+SUM(M2),DIM)=0,NULL(),DIM)

Then exclude null values on the dimension.

Regards

Andy

9 Replies
isingh30
Contributor III

Re: Filter data based in table on measure

Eliminate means you want to remove them permanently or want to hide them?

isingh30
Contributor III

Re: Filter data based in table on measure

LOAD Dim,

     M1,

     M2

FROM

(ooxml, embedded labels, table is Sheet2)where (M1+M2)<> 0;

arusanah
Contributor

Re: Filter data based in table on measure

Hi  Ishtdeep,

I want to hide them in my report.

isingh30
Contributor III

Re: Filter data based in table on measure

Above is the answer. Let me know.

arusanah
Contributor

Re: Filter data based in table on measure

But there are other visualizations which are using same dimension, and if we restrict at load we gonna lose these dimension values permanently.

isingh30
Contributor III

Re: Filter data based in table on measure

That means you need solution at UI level. Correct?

ogster1974
Honored Contributor II

Re: Filter data based in table on measure

Make your dimension a calculated one based on your condition you want to excluded

If(AGGR(SUM(M1)+SUM(M2),DIM)=0,NULL(),DIM)

Then exclude null values on the dimension.

Regards

Andy

isingh30
Contributor III

Re: Filter data based in table on measure

=if (SUM(M1)+ SUM(M2) <> 0,Dim)

arusanah
Contributor

Re: Filter data based in table on measure

Thank you Andy !!