Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator

NPrinting 19 get last 7 days

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


Labels (1)
1 Solution

Accepted Solutions
Vittore8
Creator
Author

=CB_DATE >= Num(Date(Aggr(Max(TOTAL CB_DATE ),CB_DATE ),'DD.MMYYYY')-7) --Working version!!!

View solution in original post

17 Replies
miguelbraga
Partner - Specialist III

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
Creator
Author

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

miguelbraga
Partner - Specialist III

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

Vittore8
Creator
Author

19

Vittore8
Creator
Author

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

miguelbraga
Partner - Specialist III

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
Partner - Specialist III

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
Creator
Author

19.40.3.0

Vittore8
Creator
Author

error -- cannot apply this filter