topic Re: Rolling Sum in QlikView

Rolling Sum

Fri, 21 Sep 2012 07:04:27 GMT

Hi Guys

I have two tables in following manner

Table1: There is a list box in my UI where i can select the project name

ProjId ProjName ReportId

1 test 10

1 test 11

1 test 12

1 test 13

1 test 14

Table2:

ReportId State Mode Ecomments

10 1 Y 2

11 2 Y 5

12 1 N 7

13 2 Y 9

14 2 N 1

My requirement is like when i select project test in UI then

I want to display the sum of all 'Ecomments' which satisfying the folllowing condition State=2 AND Mode=Y in a text box

Please help me

Tribhuwan

Re: Rolling Sum

Anonymous — Fri, 21 Sep 2012 07:18:36 GMT

You could use something like this:

Sum({$<State={2}, Mode={'Y'}>} Ecomments)

Re: Rolling Sum

Fri, 21 Sep 2012 07:21:57 GMT

Actually this is a sample one and I have to check for lot of constraints for a report id. Is there any way if we can do like

If( cond1 AND

Cond2 AND …….

Ecomments)

Thanks & Regards

Tribhuwan

Re: Rolling Sum

Fri, 21 Sep 2012 07:26:09 GMT

When I try like this

Sum( If( cond1

AND cond2

AND cond3………..

,Ecomments,0)

)

The result get multiplied by 6 I have no idea why this is happening.

Thanks & Regards

Tribhuwan

Re: Rolling Sum

Fri, 21 Sep 2012 07:50:45 GMT

Hi Johannes

Can you please help me why the sum is being multiplied by a fix costant.

Thanks & Regards

Tribhuwan