topic Re: Formula In Select Bar in App Development

Formula In Select Bar

Seggy224 — Sat, 16 Nov 2024 20:29:26 GMT

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

Re: Formula In Select Bar

Lisa_P — Wed, 10 Jul 2019 00:45:12 GMT

Make it a Master Dimension, then it will show title

Re: Formula In Select Bar

SergeyMak — Wed, 10 Jul 2019 01:38:50 GMT

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

Re: Formula In Select Bar

lblumenfeld — Wed, 10 Jul 2019 01:46:22 GMT

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.

Re: Formula In Select Bar

Seggy224 — Wed, 10 Jul 2019 01:53:00 GMT

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.

Re: Formula In Select Bar

Seggy224 — Wed, 10 Jul 2019 02:02:22 GMT

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.

Re: Formula In Select Bar

Seggy224 — Wed, 10 Jul 2019 02:06:32 GMT

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

Re: Formula In Select Bar

Seggy224 — Wed, 10 Jul 2019 02:52:43 GMT

Hi Lisa_P

Is there any chance you could look at this please?

https://community.qlik.com/t5/Qlik-Sense-App-Development/Backspace-deletes-last-edited-object-in-sheet-view/m-p/1598348

Re: Formula In Select Bar

bharathkamath28 — Thu, 08 Oct 2020 06:33:22 GMT

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.

Thanks,