Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Is a regular table.
How do I ignore selections?
Still "New" to Qlik Sense here, haha.
Thank you.
Assuming your expression is Sum(Measure)... You can ignore selection like this
Sum({<[Deuda Clientes]>} Measure)
or
Sum({<[Deuda Clientes] = >} Measure)
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.
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))
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.
I am not sure I understand your requirement. Would you be able to share a sample with your expected output?
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 |
| ||||
---|---|---|---|---|---|---|---|
| $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 |
Maybe it isn't even possible..