Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Seggy224
New 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
Highlighted
Employee
Employee

Re: Formula In Select Bar

Make it a Master Dimension, then it will show title

View solution in original post

Partner
Partner

Re: Formula In Select Bar

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

7 Replies
Highlighted
Employee
Employee

Re: Formula In Select Bar

Make it a Master Dimension, then it will show title

View solution in original post

Partner
Partner

Re: Formula In Select Bar

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
Contributor

Re: Formula In Select Bar

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
New Contributor III

Re: Formula In Select Bar

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
New Contributor III

Re: Formula In Select Bar

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
New Contributor III

Re: Formula In Select Bar

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

Seggy224
New Contributor III

Re: Formula In Select Bar