Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 Ambassador
Partner Ambassador

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

SergeyMak
Partner Ambassador
Partner Ambassador

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
lblumenfeld
Partner Ambassador
Partner Ambassador

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,