topic Problem with straight table (Conditional sum) in QlikView

Problem with straight table (Conditional sum)

francisvandergr — Sun, 24 Oct 2010 18:47:49 GMT

I have a problem with a straight table. When i select group 510, i wanna see in my straight table all searchcodes and in the week the total quantity of searchcodes to deliver in that week.

For example: For searchcode : PKFY-P32 VHM-E i wanna see in week 43 a quantity of 2 and in week 49 a total quantity of 1. (see purchaseorders)

We don't want select a week first. Can someone help me? I have attached an example database

Problem with straight table (Conditional sum)

Sun, 24 Oct 2010 19:04:11 GMT

Hi,

take a look at my straight table in your application. I put the delivery-week as a dimension and the rest was easy.

Ragards

Problem with straight table (Conditional sum)

francisvandergr — Sun, 24 Oct 2010 19:10:39 GMT

Thank you this works i know. The problem is that my customer want the weeks in columns. Do you know if this is possible ?

Problem with straight table (Conditional sum)

Sun, 24 Oct 2010 19:14:45 GMT

Hi,

as far a I know not with straight tables. Then I suppose you do not want to use a Pivot Table. There it is possible, to scratch the dimension into the hrizontal.

OK, ganna look at your Expression.

Problem with straight table (Conditional sum)

Sun, 24 Oct 2010 19:27:16 GMT

I build in the week as a calculated expression. Look at my app. again. Then you need to check "Supress Nulls" I think thats the way you want it. And I hided the delivery week.

Regards

Roalnd

Problem with straight table (Conditional sum)

Sun, 24 Oct 2010 19:31:26 GMT

BTW:

What about the Year. Didn't you forget the Year in your expression ?

Problem with straight table (Conditional sum)

francisvandergr — Sun, 24 Oct 2010 19:37:08 GMT

It is an example. I think i can do this by combine Year and week. Year(Leverdatum) & week(leverdatum)

Problem with straight table (Conditional sum)

francisvandergr — Sun, 24 Oct 2010 19:42:56 GMT

But a better solution is always welcome of course !

Problem with straight table (Conditional sum)

Sun, 24 Oct 2010 19:47:29 GMT

Oh,

and I found two other things concerning your expressions:


sum(If (Week(Ink\Leverdatum) = Week (Today())+1, (Ink\Aantal),0 ))

To work correct, the sum has to be outside. The if is inside the sum. Means, you want to sum the the content of Aantal, when the weeks are matching. Else not.

And I am sure you want to compare with the next week "week() +1", and not with the week of the next day ( week(today+1) )

If you correct that, your app should work. Sorry, that I saw these topics too late.

Roland

Problem with straight table (Conditional sum)

francisvandergr — Sun, 24 Oct 2010 20:10:03 GMT

Thnx for your time. You helped me very much!! It works