Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

csurajbhan
New Contributor II

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

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.

Screen1.pngScreen2.png

1 Solution

Accepted Solutions

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

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


talk is cheap, supply exceeds demand
8 Replies

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

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


talk is cheap, supply exceeds demand
csurajbhan
New Contributor II

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

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

What about Complex calculated dimension?

What about it? What's the question?


talk is cheap, supply exceeds demand
maxim1500
Contributor

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

I might have an example:

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

maxim1500
Contributor

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

I found the solution:

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

rvijayanth
New Contributor III

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

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)

csurajbhan
New Contributor II

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

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

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.


talk is cheap, supply exceeds demand
Community Browser