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
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!

Tags (2)
Labels (2)

• Select Bar

2 Solutions

Accepted Solutions
Employee

Re: Formula In Select Bar

Make it a Master Dimension, then it will show title

Highlighted
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
7 Replies
Employee

Re: Formula In Select Bar

Make it a Master Dimension, then it will show title

Highlighted
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
Contributor

Re: Formula In Select Bar

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

Let me know if this helps.

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.

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.

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.

New Contributor III