New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for
Did you mean:
Contributor

Straight table hide expression value

Hi,

I'm trying to hide rows in a straight table if the expression returns a value between -0.05 and 0.05.
Until now this seems to be impossible.

Anyone willing to accept this challenge?

Here is my table:

For dimensions it is possible to hide 0 values.

However, my column 'Afwijking' has a pretty long calculation, including Sum (so you can't make it a dimension as far as I know).

Therefore, I tried to make 'Journaalpost' empty if the value of 'Afwijking' is between -0.05 and 0.05.
If I manage to do this I can hide the empty values on this dimension.

I made the calculation of 'Afwijking' as a variable named vAfwijking.

What I tried so far (and dind't work)
1) If(not Match(\$(vAfwijking),'0.00','0.01','0.02'),ID_JOURNAALPOSTNR)
2) Aggr(Only({\$<
(\$(vAfwijking))={">0"}
>}ID_JOURNAALPOSTNR),ID_JOURNAALPOSTNR)

Tried these in like 40 possible ways but can't figureout how to make it work.

Thnx,

Mike

1 Solution

Accepted Solutions
Partner

In Nummer dimension, click on fx and try this:

=if(aggr(fabs(round((SUM(amount)*0.19)-sum(tax),0.01)),Nummer)>0,Nummer,null())

Uncheck "Include null values".

Thanks and regards,

Arthur Fong

4 Replies
Partner

You have a sample app?

Contributor II

Hi Arthur,

i'm a collegue of Mike and i have made a simple example app.

Only the lines with a deviation > 0 are relevant. We want to hide the other lines.

Lars

Partner

Hi,

in every measure put the expression of deviation like this,

if(deviation>0,sum(measure)) and in Add-on tab of straight table uncheck the include null or zero values checkbox.

this might hit on performance but think so you can achieve what is required.

Thanks & Regards,

Prashant

Partner

In Nummer dimension, click on fx and try this:

=if(aggr(fabs(round((SUM(amount)*0.19)-sum(tax),0.01)),Nummer)>0,Nummer,null())

Uncheck "Include null values".

Thanks and regards,

Arthur Fong