Dynamic filter in Nprinting

[#1]

Hello All,

I need to create a filter for 4 weeks for a specific table.

I used the below in Qlikview load script to create the week:

WEEK(subfield([CallUniversalTime], ' ' ,1)) as Semaine,

In Nprinting here is how I created the filter:

But unfortunately Nprinting is not creating the other values:

Any idea?

Many Thanks,

Hasvine

[Daniel_Jenkins · Accepted solution]

Hi Hasvine,

That's because you are reducing the day by 0, 1, 2 & 3 and all are probably still falling in the same week. Move the - n outside the brackets to reduce week by n:

HTH - Daniel

[#3]

Thanks for your answer.

It works 😄

[avinashelite]

if you have got the answer, mark the correct and helpful answers