Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeRadem
Contributor
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:

Table.png

 

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.

Can any one please help with this?

Thnx,

Mike

1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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())

MC.PNG

Uncheck "Include null values".

 

Thanks and regards,

Arthur Fong

View solution in original post

4 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

You have a sample app?

Lars_Esser
Contributor II
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. 

Many Thanks in advance!

Lars

Prashant_Naik
Partner - Creator II
Partner - Creator II

Hi,

this might help you,

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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())

MC.PNG

Uncheck "Include null values".

 

Thanks and regards,

Arthur Fong