Filter Pane: How to apply to every column on a table?

[patriciousa]

Hi community experts. I'll appreaciate your help to solve something for me.

I have a Filter Pane and a Table on my sheet.

"Deuda Clientes" is my filter pane.

I need it to ONLY and ONLY apply to an specific column on the table.

Not sure if it is important but that specific column has this expression:

"sum(aggr(if(TODAY(2)>(BLDAT+ZBD1T), Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR)

-Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))"

Thank you in advance.

Regards.

[sunny_talwar]

Is this a pivot table or a regular table? also, if it is a table, then you would have to ignore selection in all your other expression except this one. You should add {<[Deuda Clientes]>} to ignore selections I guess

[patriciousa]

Is a regular table.

How do I ignore selections?

Still "New" to Qlik Sense here, haha.

Thank you.

[sunny_talwar]

Assuming your expression is Sum(Measure)... You can ignore selection like this

Sum({<[Deuda Clientes]>} Measure)

or

Sum({<[Deuda Clientes] = >} Measure)

[patriciousa]

Wait, Its getting difficult.

My expression on the table which i want to ignore is:

SUM(Aggr(if((TODAY( 2)-(BLDAT+ZBD1T))>0 and (TODAY( 2)-(BLDAT+ZBD1T))<=30,

Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR)-Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))

My Filter pane field is:

DMBTR.

DMBTR is the sales number, which can be 0,02, 0,033, 4000, 210304, etc

Still don't know how to do it.

Thank you Sunny.

[sunny_talwar]

May be try this:

Sum({<DMBTR>} Aggr(If((Today(2) - Only({<DMBTR>} BLDAT+ZBD1T))>0 and (Today(2) - Only({<DMBTR>} BLDAT+ZBD1T))<=30,

Sum({<"SHKZG"={S} ,"ZLSCH"-={"J"}, DMBTR>} DMBTR) - Sum({<"SHKZG"={H}, "ZLSCH"-={"J"}, DMBTR>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))

[patriciousa]

Sunny. It's not working because I just realize I have not been clear enough.

I have a regular table with many expressions.

One of the columns have this:

sum(aggr(if(TODAY(2)>(BLDAT+ZBD1T), Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR)

-Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))

That column shows sales.

I need to make a numeric filter pane to only apply to that column.

I want to be able to search for those <1000, or =1595 or <9493 or >39304 or whaterver I want.

Is it even possible?

Thank you in advance.

Regards.

[sunny_talwar]

I am not sure I understand your requirement. Would you be able to share a sample with your expected output?

[patriciousa]

I have the following regular table on my qlik sense sheet.

x1	x2	x3	sum(aggr(if(TODAY(2)>(BLDAT+ZBD1T), Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR) -Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))
$14	$1949	$9384	$39
$323	$3244	$1	$39403
$32	$312	$12	$7
$32	$0,5	$123	$394

I want a Filter Pane on top of the table that allows me to search IN column number 4 for custom values.

For example, I would like to search values less than 1000.

The result should be:

x1	x2	x3	sum(aggr(if(TODAY(2)>(BLDAT+ZBD1T), Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR) -Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))
$32	$312	$12	$7
$14	$1949	$9384	$39
$32	$0,5	$123	$394

Now the same filter pane should also let me type a different search, like over 10.000

Result:

x1	2	x3	sum
$323	$3244	$1	$39403

[patriciousa]

Maybe it isn't even possible..