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: 
Seggy224
Contributor III
Contributor III

Formula In Select Bar

Is there any way to stop this happening? The formula appears in the select bar rather than the filter title!

 

Capture.PNG

Labels (2)
2 Solutions

Accepted Solutions
Lisa_P
Employee
Employee

Make it a Master Dimension, then it will show title

View solution in original post

SergeyMak
Partner
Partner

Try to move your formula  isNull into Load Script and remove it from your calculated dimension.

It should fix the issue and also improve your performance as calculated dimensions have an impact on app's performance

Regards,
Sergey

View solution in original post

8 Replies
Lisa_P
Employee
Employee

Make it a Master Dimension, then it will show title

View solution in original post

SergeyMak
Partner
Partner

Try to move your formula  isNull into Load Script and remove it from your calculated dimension.

It should fix the issue and also improve your performance as calculated dimensions have an impact on app's performance

Regards,
Sergey

View solution in original post

lblumenfeld
Luminary Alumni
Luminary Alumni

Please take a look at my blog post on this topic. I think it will solve your problem.

http://qlikwithfriends.com/index.php/2018/02/25/using-aggr-instead-of-if-for-complex-dimensions/

Let me know if this helps.

Seggy224
Contributor III
Contributor III
Author

Thanks for the advice Lisa_P and that worked.

Obviously the caveat is that the master dimension name  appears as the select bar item title. Any title information is ignored just the same as any ordinary dimension.

 

 

Seggy224
Contributor III
Contributor III
Author

Thanks lblumenfeld

An interesting approach that seems to fix something that seems illogical to me in the first place.

Not sure how AGGR would handle this formula though:

=if(isnull(PreviousArrivalIntervalDays)
,'No Previous'
,if(PreviousArrivalIntervalDays=0
,'Same Day'
,if(PreviousArrivalIntervalDays=1
,1
,if(PreviousArrivalIntervalDays=2
,2
,if(PreviousArrivalIntervalDays>2 and PreviousArrivalIntervalDays < 30
,'3 - 30'
,if(PreviousArrivalIntervalDays<366
,'31 - 365'
,if(PreviousArrivalIntervalDays>365,'366+')
))))))

however I am a relative beginner happy to learn more.

 

Seggy224
Contributor III
Contributor III
Author

Thanks Sergey_maka8. I understand that this is a good option too and relatively easy to implement.

Seggy224
Contributor III
Contributor III
Author

bharathkamath28
Contributor III
Contributor III

Hi All,

 

I have similar issue, tried creating master dimension.

But still i see the formula on the selection bar.

How to resolve this issue.

bharathkamath28_0-1602138795552.png

 

Thanks,