Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

patriciousa
Contributor

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

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.

13 Replies
MVP
MVP

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

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
Contributor

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

Is a regular table.

How do I ignore selections?

Still "New" to Qlik Sense here, haha.

Thank you.

MVP
MVP

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

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

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

or

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

patriciousa
Contributor

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

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.

MVP
MVP

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

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
Contributor

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

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.

MVP
MVP

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

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

patriciousa
Contributor

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

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

x1x2x3

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:

x1x2x3

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:

x12x3sum
$323$3244$1$39403
patriciousa
Contributor

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

Maybe it isn't even possible..