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

[csurajbhan]

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.

[Gysbert_Wassenaar · Accepted solution]

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

[csurajbhan]

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.

[Gysbert_Wassenaar]

What about Complex calculated dimension?

What about it? What's the question?

[maxim1500]

I might have an example:

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

[maxim1500]

I found the solution:

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

[rvijayanth]

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]

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.

[Gysbert_Wassenaar]

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.

[bharathkamath28]

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,