topic Re: Filter fields in Straight Table in QlikView

Filter fields in Straight Table

achitreskyitgroup — Tue, 11 Aug 2020 20:26:39 GMT

Hello Guys,

In the adjoining straight table, I need to filter data for all the values in column F which are negative or 0. Is there a way by which I can remove the whole row associated with negative column F?

Column F is a calculated expression ($vSales). I only need rows with sales > 0 populating in the table.

Re: Filter fields in Straight Table

Kushal_Chawda — Tue, 11 Aug 2020 21:26:24 GMT

You can use calculated dimension like below

=aggr(if($(vSales)>0,$(vSales),null()),Dimension1)

where Dimension1 is first dimension of your table.

then check "supress null value" option for that dimension

Re: Filter fields in Straight Table

achitreskyitgroup — Wed, 12 Aug 2020 17:02:20 GMT

Hey, thanks Kush but it doesn't work

Re: Filter fields in Straight Table

Kushal_Chawda — Wed, 12 Aug 2020 21:25:39 GMT

sorry my bad. try below calculated dimension for first dimension of straight table

=aggr(if($(vSales)>0,Dimension1,null()),Dimension1,Dimension2,Dimension3)

where Dimension1,Dimension2,Dimension3 are straight table dimensions. You need to include all dimensions in aggr.

Another option: You can put sales>0 condition in all expression of straight table and check "suppress zero value" option in presentation tab of chart properties

Assuming your first expression of straight table is for Sales

Expression1: if($(vSales)>0,$(vSales),0)

Expression2: if($(vSales)>0,ActualSecondExpression,0)

Expression3: if($(vSales)>0,ActualThirdExpression,0)

Expression4: if($(vSales)>0,ActualFourthExpression,0)