Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
csurajbhan
Contributor II
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

9 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

csurajbhan
Contributor II
Contributor II
Author

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?


talk is cheap, supply exceeds demand
maxim1500
Partner
Partner

I might have an example:

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

maxim1500
Partner
Partner

I found the solution:

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

rvijayanth
Creator
Creator

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
Contributor II
Contributor II
Author

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.


talk is cheap, supply exceeds demand
bharathkamath28
Contributor III
Contributor III

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'))

bharathkamath28_0-1602139215268.png

 

Thanks,