Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic set modifier

In Qlik Sense 3.0 I used below code to make a dynamic set modifier.

It was working perfect. All fields from Dim_Calendar were ignored if selected.

It was a great way to ignore: date, week, month, year, etc. selections

worked in QS 3.0

******************************************

Sum({$<

             $(='[$(=Concat({1<$Table={'Dim_Calendar'}>}distinct $Field,']=,[')&']=')')

>}M_Quantity)

******************************************

However after upgrading to QS June 2017 this code stopped working.

Anyone who can help?

2 Replies
Anonymous
Not applicable
Author

Try to add this line at the beginning of the load script:

///$bnf off


Reload.  Let me know if it fixes the problem

Anonymous
Not applicable
Author

Great. It has helped!

Thank you so much.

Have a great weekend!