topic Re: conditional sum in QlikView

conditional sum

Wed, 20 Aug 2014 05:14:25 GMT

hello

i have a table like this:

id	d Day	Sales
1	1	50
2	1	100
3	2	20
4	2	50
5	3	300
6	3	20

i want to show the user sum of sales for the days befor than the day number he give as an input, i wrote it but it doesn't work :

Sum ({ <[Sales]={">=0"} , [d Day]={"$(<=CD)"}>}[Sales])

any one knows what is the problem?

thank you

azizi

Re: conditional sum

ashfaq_haseeb — Wed, 20 Aug 2014 05:33:05 GMT

Hi,

Your request is not clear.

Can you explain what is the output you expect here.

Regards

ASHFAQ

Re: conditional sum

jonathandienst — Wed, 20 Aug 2014 05:35:03 GMT

What is CD? You might need [d Day]={"<=$(=CD)"}

Re: conditional sum

Wed, 20 Aug 2014 05:41:07 GMT

sorry, the syntax i have wrote is this:

Sum ({ < [d Day]={"$(<=CD)"}>}[Sales])

and CD is an input value. i want just the sum of sales that are before than the day that user gives me as an input(CD).

Re: conditional sum

Wed, 20 Aug 2014 05:41:18 GMT

sorry, the syntax i have wrote is this:

Sum ({ < [d Day]={"$(<=CD)"}>}[Sales])

and CD is an input value. i want just the sum of sales that are before than the day that user gives me as an input(CD).

Re: conditional sum

ashfaq_haseeb — Wed, 20 Aug 2014 05:44:14 GMT

Hi,

Try below

Sum ({ < [d Day]={"<=($(=(CD - 1))"}>}[Sales])

Regards

ASHFAQ

Re: conditional sum

jagan — Wed, 20 Aug 2014 05:49:53 GMT

Hi,

Try like this

Sum ({ <[Sales]={">=0"} , [d Day]={"<=($(=(CD - 1))"}>}[Sales])

Sum ({ <[Sales]={">=0"} , [d Day]={"<($(=(CD))"}>}[Sales])

Regards,

Jagan.

Re: conditional sum

Wed, 20 Aug 2014 05:53:15 GMT

hi Ashfagh.

if the user give 3 as input i want to have sum of sales with [d Day]=1,2,3 and not just for [d Day]=2

i mean all the days before the day he gave as CD.

Re: conditional sum

jagan — Wed, 20 Aug 2014 05:55:58 GMT

Hi,

Then try this

Sum ({ <[Sales]={">=0"} , [d Day]={"<=($(=(CD))"}>}[Sales])

Regars,

Jagan.

Re: conditional sum

ashfaq_haseeb — Wed, 20 Aug 2014 05:56:22 GMT

Try below

Sum ({ < [d Day]={"<=($(=(CD))"}>}[Sales])

Re: conditional sum

Wed, 20 Aug 2014 06:10:10 GMT

no it doesn't work

Re: conditional sum

Wed, 20 Aug 2014 06:10:19 GMT

no it doesn't work

Re: conditional sum

ashfaq_haseeb — Wed, 20 Aug 2014 06:11:24 GMT

Hi,

Can you attached your sample file.

Regards

ASHFAQ

Re: conditional sum

Wed, 20 Aug 2014 06:15:22 GMT

thank all! specially Jonathan.

[d Day]={"<=$(=CD)"}

Re: conditional sum

jagan — Wed, 20 Aug 2014 06:17:36 GMT

Hi,

This should definitely work, if not attach your file

Sum ({ <[d Day]={'<=$(=CD)'}>}[Sales])

Regards,

Jagan.