Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ma_zebra
New Contributor

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
mov
Esteemed Contributor III

Re: Dynamic set modifier

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

///$bnf off


Reload.  Let me know if it fixes the problem

ma_zebra
New Contributor

Re: Dynamic set modifier

Great. It has helped!

Thank you so much.

Have a great weekend!