Scripto 101 for doffies pls

[#1]

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...

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[#3]

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

[morganaaron]

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!

[#5]

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