topic Re: Scripto 101 for doffies pls in QlikView

Scripto 101 for doffies pls

Thu, 23 Apr 2015 14:35:03 GMT

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

Re: Scripto 101 for doffies pls

Gysbert_Wassenaar — Thu, 23 Apr 2015 16:40:53 GMT

Please read these two documents:

Re: Scripto 101 for doffies pls

Fri, 24 Apr 2015 14:02:19 GMT

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

Re: Scripto 101 for doffies pls

morganaaron — Fri, 24 Apr 2015 14:08:20 GMT

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!

Re: Scripto 101 for doffies pls

Fri, 24 Apr 2015 14:22:59 GMT

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