Set analysis help please

[Anonymous]

Hiya

I need help with Set- Analysis please.

What i wanted to do was to set up my report so if the user selects week 1, budget volume goes to week 2

(used for next week results)

My field in script for week is

Week_No

And my budget volume is

[Budget Vol]

Thanks

Can someone advise good place to learn set analysis been on here but don't know how to use it

Set Analysis Wizard for QlikView | qlikblog.at

[Anonymous]

Hi All

I found something which could be an issue. There is in the week column

week

1

2

3

4

Jan Adj

5

6

7

8

Feb Adj

Do you think because of these words in the number field the syntax is not working?

Sum({<Week={$(=Max(Week)+1)}, Week=>} [Budget Vol])

[agilos_mla]

Yes Adil,

As I said in my previous answer the "Adj" column in Week makes ther set analynis not perform correctly.  Does it have a business meaning otherwise try to filter it in the load script 

WHERE wildmatch(Week, '*Adj*') = 0;

Michael

[#4]

Hi try:

Sum({<Week={'$(=Max({<Week-={'*Adj*'}>}Week)+1)'}>} [Budget Vol])

or

sum({<Week={'$(=(max(Week)+1))>}[Budget Vol])

[mikecrengland]

I think the problem is that set analysis is calculated once for the chart, not row by row. So if you are trying to display multiple weeks (for example a bar chart with week as a dimension) QlikView gets confused. I had a similar problem and solved it with a bunch of variables and a valuelist. I wrote it up at Fortune Cookie BI: If you can't learn it after six times...

It doesn't sound like you need your user to decide on the offset, but this might help.

Mike

[#6]

try like this hope will helps you

create variable as

Vmaxweek=max(Week)+1

sum({<Week={$(Vmaxweek)}Budget Vol])