topic Re: Help with Above() in QlikView

Help with Above()

don_qlikview — Tue, 09 Sep 2014 20:27:10 GMT

Hello Everyone,

I have a requirement where I have to get the values from previous calculation if the numbers are not present. For example for week 3 & week 4 I need to derive the values from Week 2. So, I am using above() to get to my answer and when I use the above() function the below table1 becomes like that in table 2 as shown

Table 1:

Week	Sum(Amount)
1	1000
2	2000
3	0
4	0
5	3000

Table 2:

Week	Above(Sum(Amount))
1	1000
2	2000
3	2000
4	0
5	3000

I want to have Week 4 also as 2000. So, can anyone help me to get that or is there a better way to do this?

Thanks,

Don

Re: Help with Above()

Tue, 09 Sep 2014 20:29:13 GMT

would using sum(above(amount)) be a better representation of what you're trying to go for?

Re: Help with Above()

don_qlikview — Tue, 09 Sep 2014 20:33:59 GMT

Hi Robert,

I want to show Week 4 as also 2000.

Re: Help with Above()

Tue, 09 Sep 2014 20:36:06 GMT

I'm not sure I fully understand what your scenario is, could you share a sample qvw?

Re: Help with Above()

don_qlikview — Tue, 09 Sep 2014 20:47:28 GMT

I have attached a sample QVW...

Re: Re: Help with Above()

peschu123 — Tue, 09 Sep 2014 21:32:30 GMT

Hi Don,

please take look at attached script file. Its not an exact answer on your question but perhaps it helps.

I would say the reason why above "doesn't work" in week 4 is because sum(Amount) in week3 = 0. If you know that this happens only 2 times you could just use another "IF".

Like that:

IF(sum(Amount)=0,IF(Above(sum(Amount))=0,Above(sum(Amount),2),Above(sum(Amount))),Amount)

I have to admit that it looks not very nice and if possible I would do it in script.

If needed I can upload a sample qvw tomorrow.

Best Regards,

Peter

Re: Help with Above()

don_qlikview — Tue, 09 Sep 2014 23:59:54 GMT

If you can upload a sample qvw, that'll be great... thanks for the help!!!

Re: Re: Help with Above()

peschu123 — Wed, 10 Sep 2014 08:01:12 GMT

Hi,

take a look at attached example.

Re: Help with Above()

don_qlikview — Wed, 10 Sep 2014 15:11:47 GMT

This works... Thanks!!!!