topic Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar in App Development

Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

csurajbhan — Fri, 09 Dec 2016 07:07:08 GMT

Hi All,

If i will use filter object with certain calculation or chart dimension with calculation in qliksense,

while selecting value from filter or chart dimension, the formula or expression is displaying on selection bar.

though i assigned a title for filter or label for dimension of chart , the formula is still visible on selection bar instead of label or title.

Find the attached .qvf file with below screenshot.

Please provide solution on this.

Thanks in Advance.

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

Gysbert_Wassenaar — Fri, 09 Dec 2016 08:33:12 GMT

Try aggr(only({1<Dim2-={'a','b'}>}Dim2),Dim2)

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

csurajbhan — Mon, 12 Dec 2016 11:52:07 GMT

Hi Gysbert,

Many thanks for your help.It is working fine for filter.

What about Complex calculated dimension? Might it is not possible to use complex calculation with aggr always.

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

Gysbert_Wassenaar — Mon, 12 Dec 2016 11:58:38 GMT

What about Complex calculated dimension?

What about it? What's the question?

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

maxim1500 — Wed, 04 Jan 2017 15:28:26 GMT

I might have an example:

IF ('$(=vLanguage)' = 'FR', [Security Name (Number) French], [Security Name (Number) English])

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

maxim1500 — Wed, 04 Jan 2017 18:54:27 GMT

I found the solution:

AGGR(IF ('$(=vLanguage)' = 'FR', [Security Name (Number) French], [Security Name (Number)]), [Security Name (Number)]) would work in this case.

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

rvijayanth — Mon, 01 May 2017 15:09:20 GMT

Hey, I need help in writing expression for the same except i want it to be greater than a variable:

Im trying this but it is not working:

aggr(only({1<date_year={">$(vLimitYearVersion)"}>}date_year),date_year)

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

csurajbhan — Sat, 13 May 2017 12:23:35 GMT

hi Gysbert,

After applying aggr(only({1<Dim2-={'a','b'}>}Dim2),Dim2) it is very hard to find find or search field value from filter.

Search operation required *.

Can we search the field value without applying wild character , currently available in normal filter pane.

Thanks In advance.

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

Gysbert_Wassenaar — Sun, 21 May 2017 07:31:08 GMT

Nope. What you can try instead is first select 'a' and 'b' in Dim2. Then invert the selection in Dim2 using Select Excluded. And then Lock the selections in Dim2. After that you can make selections anywhere else without problems.

Re: Qliksense - Calculated Filter object formula/expression is visible on Selection Bar

bharathkamath28 — Thu, 08 Oct 2020 06:40:26 GMT

Hi @Gysbert_Wassenaar

I need your help to convert the expression to aggr.

With the below expression i can see the FORMULA on the selection bar.

=if ( $(=count(distinct DateA)>12) , Year(DateA), date(DateA,'DD:MMM:YYYY'))

Thanks,