Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Show calculated values from Straight table in Filter Pain

Hi There

I have following requirement,

I have created straight table in my QS App. In one column I am calculating values like below

(FABS((Column(1) - Column(2))/Column(2)))*100. The values are coming correct.

Now what I am trying to do , create "filter pane" and show all values which are derived from above formula.

Please find attached screenshot.

Thanks in advance.

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Show calculated values from Straight table in Filter Pain

Not the case for me:

Capture.PNG

try to aggregate by the dimension of your table; Product I think

5 Replies
jaimeaguilar
Valued Contributor II

Re: Show calculated values from Straight table in Filter Pain

Hi,

it does not work like that. The column() function only works within the object (table, chart). If you need to use the same formula outside the table/chart, then you need to use the complete expression,

hope this helps,

regards

ashishpalkar
Contributor II

Re: Show calculated values from Straight table in Filter Pain

Hi

Thanks for your reply, I am using variables instead of column () function. This is just example .

My question is how can we use measure in the filter pain.

this is my actual formula - >  (FABS(($(Sales1) - $(Rev2))/$(Rev2)))*100

Thanks again.

OmarBenSalem
Esteemed Contributor

Re: Show calculated values from Straight table in Filter Pain

filter pane is a dimension; not a measure; this is why you're not getting any result; u need to aggregate it with sthing :

aggr( yourMeasure ,aDimension)

ashishpalkar
Contributor II

Re: Show calculated values from Straight table in Filter Pain

Thanks Omar

How ever I am getting only one value in the list when use this

aggr( yourMeasure ,aDimension)

OmarBenSalem
Esteemed Contributor

Re: Show calculated values from Straight table in Filter Pain

Not the case for me:

Capture.PNG

try to aggregate by the dimension of your table; Product I think

Community Browser