- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=CB_DATE >= Num(Date(Aggr(Max(TOTAL CB_DATE ),CB_DATE ),'DD.MMYYYY')-7) --Working version!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I work with QlikSence I need to create a variable there???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sure, but before that what is the version of the NPrinting are you working on?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
19
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
nprinting requires value, what value should I write if I load a variable with a value already from qlik sense
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There are many 19's version, can you please provide the patch number? Please provide further information from About section in the Web Console.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
19.40.3.0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
error -- cannot apply this filter
- « Previous Replies
-
- 1
- 2
- Next Replies »