
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Scripto 101 for doffies pls
Example:
Cal Week 17
Require Week 16 (ie one week back)(effectively ignoring current week data)
Have static data off spread sheet namely weekly usage
expression = ?
my world = 16 x weekly usage
Problem is = I need ytd sales (actual) up to week 16
Hence I can calculate % penetration into my customer base
ie 16 x 2000 = 32000 vs 25000 = 78%
happy hunting... any ideas...
- Tags:
- new_to_qlikview

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please read these two documents:
- QlikCommunity Tip: How to get answers to your post?
- Preparing examples for Upload - Reduction and Data Scrambling
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks Gysbert.
This doesnt really answer my question as its a string of text that i cant get right.
the example i have given doesnt require any uploads.
thanks again. im sure i will come right soon.
cheers


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think what Gysbert was suggesting was that your question is phrased in a very abstract manner - it's hard to follow what story you're putting together, and your title doesn't explain what you're after at all - try to include a reference to your actual question.
If your current week is 17 though, you can get your previous week by using Max(Week)-1 - in order to use that within a ytd setting, you'd want to use:
Sum({<Week={'<=$(=Max(Week)-1)'}, Month>}Sales)
As an example. That would sum your sales for all previous weeks up to your max week, but would still be limited by other selections (i.e. year) but is ignoring your month selection to ensure it's ytd and a month selection wouldn't alter it.
As for your last part "ie 16 x 2000 = 32000 vs 25000 = 78%" - no idea what you mean here, sorry!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
ok i will endevour to support what im trying to do a bit better as well as title it better.
i think your answer can assist me.
thanks
