NPrinting 19 get last 7 days

[Vittore8]

Hi, I choose advanced search and write this,  =CB_DATE >= Max(Num(CB_DATE))-7 why doesn't it work?

[miguelbraga]

Hi Vittoe8,

I think the problem here is that you'll need to make a variable such as this:

Let vLast7Days = Max(Num(CB_DATE))-7;

Then create a filter with the field CB_DATE and then in the textbox on the right of the Advanced Search right down this:

=[CB_DATE] >= $(vLast7Days )

Before hand, you must see if this expression "Max(Num(CB_DATE))-7" gives you the right result and that the variable gives you the same value.

Try it and let me know if it worked pal.

Kind regards,

MB

[Vittore8]

I work with QlikSence I need to create a variable there???

[miguelbraga]

Sure, but before that what is the version of the NPrinting are you working on?

[Vittore8]

19

[Vittore8]

nprinting requires value, what value should I write if I load a variable with a value already from qlik sense

[miguelbraga]

There are many 19's version, can you please provide the patch number? Please provide further information from About section in the Web Console.

[miguelbraga]

I'm not sure what is your version specifically, but it might be required to click on Evaluate value and then put something like this:

>=Max(Num(CB_DATE))-7

Can you please try that? Please don't forget to tick the Evaluate box bellow Value.

[Vittore8]

19.40.3.0

[Vittore8]

error -- cannot apply this filter