Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter record in a Straight Table based on a calculation Field

Hello everyone,

I got a problem with filter the record out based on a calculation Field. Hope somebody can help

I have a table that contain two mesasure plus one calculation column to show the difference .

Example:

2012-06-14_190014.jpg

I would like to add a filter on the right for user selection .

If the user select Match , then only the difference equal to 0 will show ,

If the user select Not match , then only the difference equal to 0 will show ,

If not select , all the record show up.

More information:

Because the difference column is calculate based on a aggregated level, i can't per -calculate on loading script

he under level data may be like

Example:

CED     Dim1     1     2

CED     Dim2     2     1

Any idea ?

1 Reply
Anonymous
Not applicable
Author

Not sure how well this will play with more data but you can create a calculated dimension:

=aggr(if(Match='Match' and sum([A Amount])-sum([B Amount])=0,Dim,

          if(Match='No Match' and sum([A Amount])-sum([B Amount])<>0, Dim,

                    if(isnull(Match), Dim))), Dim)

Then just check "Suppress if value is null" for the dimension and it should show what you expect in the example.