topic Re: Re: how to write the expression. in QlikView

how to write the expression.

Tue, 15 Oct 2013 06:05:38 GMT

pls find the attached file.

Re: how to write the expression.

rajni_batra — Tue, 15 Oct 2013 06:14:53 GMT

Hey,

Can you plz elaborate ur requirement its not clear or give some dummy data with required output.

Regards,

Rajni

Re: how to write the expression.

Tue, 15 Oct 2013 06:25:06 GMT

Hi Rajni,

as in excel i have shown

there are different location code , on which thy have different size items. if the user select location code ,the available sizes on that location get checked .

if there quantity is greater than 0 thn it would show sum(quantity) else 0.

for example

sizes 4 5 6 7

no of quantity 1 1 2 4

Thanks!!!

Re: how to write the expression.

Tue, 15 Oct 2013 06:33:37 GMT

I guess the expression you have mentioned in the attachment is fine. If(size>0,Sum(Quantity),0)

Re: Re: how to write the expression.

tresB — Tue, 15 Oct 2013 06:36:58 GMT

May be like attached sample

Re: how to write the expression.

Tue, 15 Oct 2013 06:49:59 GMT

Hi Treseco thanks for reply..

but the requirement is:

for example

location code size quantity

101 6 0

101 8 1

101 10 2

102 6 3

102 8 2

102 10 2

output:

since size 6 is not available at 101 so it would show 0 for 101. and at 102 all three sizes are availabe so it would show 3+2+2=7.

Re: how to write the expression.

Tue, 15 Oct 2013 06:59:27 GMT

Create a Pivot Table and Just go into its properties and select Supress Null Values from Presentation Tab. and Mark Check the Partial Sum.

Re: Re: how to write the expression.

Tue, 15 Oct 2013 07:03:48 GMT

See the attachment

Re: Re: how to write the expression.

tresB — Tue, 15 Oct 2013 07:20:48 GMT

Sourabh,

It seems that you want to show data for all combinations of Code and Size even if there is no data. If so, you have to work in the script to generate the missing values with zero. For reference you can have a look at :

How to populate a sparsely populated field and Generating Missing Data In QlikView

Re: Re: Re: how to write the expression.

Tue, 15 Oct 2013 07:27:00 GMT

hi hannan,

here partial sum option is disable for sum field . please see the attachment for reference.

Thanks

Re: Re: how to write the expression.

Tue, 15 Oct 2013 07:31:37 GMT

Go into your expressions and promote the sum expression to get its partial sum.

Re: Re: how to write the expression.

Tue, 15 Oct 2013 07:33:58 GMT

there is only one exp i.e. sum. code is the dimension