Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks for your answer.
It works 😄
if you have got the answer, mark the correct and helpful answers