Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
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?


1 Solution

Accepted Solutions
Vittore8
Creator
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
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
Creator
Author

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

Vittore8
Creator
Creator
Author

19

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

19.40.3.0

Vittore8
Creator
Creator
Author

error -- cannot apply this filter