topic Computing Sums with different Dates and Dimensions in QlikView

Computing Sums with different Dates and Dimensions

Mon, 16 Apr 2012 10:57:58 GMT

Hy people,

I have a litle problem making a sum procedure and i'm not sure witch is the best way to deal with it.

Imagine:

Variable A , witch have to number 1 and 2;

Variable B, witch is a date and has 10 entries from 2011 (the dates differ with the number 1 or 2 from variable A)

Variable C, witch is sales

Not i want a table like that:

Variable A Variable B Variable C

1 Min(Variable B) Sum({$<Variable B={$(=min(Variable B))>} Variable C)

2 Min(Variable B) Sum({$<Variable B={$(=min(Variable B))>} Variable C)

When i apply this it doesnt work and mybe is because is assuming the min data for the entiry database and not for the Dimension of Variable A.

I solve out if i compute the min of each Variable A in script but mybe should be an easy way to deal with it.

Anyone could help?

Thanks,

Eliano

chematos — Mon, 16 Apr 2012 14:30:48 GMT

Hi Eliano,

maybe is not working because the syntax, you could add the comas, try this:

Sum({$<Variable B={"=$(=min(Variable B))" } >} Variable C)

Regards,

Chema

Mon, 16 Apr 2012 15:03:57 GMT

It's not working.

I've tried in different forms.

jonathandienst — Mon, 16 Apr 2012 15:18:14 GMT

If those are the actual field names, you will need to wrap with [ ], as in [Variable A] and use the expression in the previous post.

Regards

Jonathan

Mon, 16 Apr 2012 16:52:57 GMT

Jonathan, thanks.

Its not that problem.

Is quite difficult actually because he needs to compute the minimum date of each variable a and them sum the expression.