topic Re: Hi everybody, in QlikView

Hi everybody,

Fri, 06 May 2016 14:28:27 GMT

I have an issue that concerns calculation of total of quantity of two products for all the clients that I have.

I have 'Prdt1' and 'Prdt2'.

I have this expression :

Sum(Total {$1<Product={'Prdt1' ,'Prdt2'}>}Quantity).

but the xpression changes everytime i make a selection. I wanna calculate the total regardless to selections.

Please if anyone can help me I will be very grateful.

Thank u

Re: Hi everybody,

Kushal_Chawda — Fri, 06 May 2016 16:26:27 GMT

Sum({1<Product={'Prdt1' ,'Prdt2'}>}Quantity).

Re: Hi everybody,

sunny_talwar — Fri, 06 May 2016 16:30:13 GMT

Instead of $1, you just need 1

Sum(Total {1<Product={'Prdt1' ,'Prdt2'}>}Quantity)

Not sure if Total is needed or not

Re: Hi everybody,

trdandamudi — Fri, 06 May 2016 16:48:19 GMT

Replace $1 with 1 and you don't need Total in the expression.

Re: Hi everybody,

Fri, 06 May 2016 16:51:20 GMT

It doesn't work guys.

I have in addition to product, their segments so when I choose a segment the total changes and I don't want it to change .

I want to have the total of quantity of 'Prdt1' and 'Prdt2' ignoring all the selections I make.

Please Help !!!!!

Re: Hi everybody,

sunny_talwar — Fri, 06 May 2016 17:11:44 GMT

Would you be able to share a sample showing the issue? I don't think it should happen, but it could be due to some other unknown reason to us. We might be able to see the issue when you share the sample

Re: Hi everybody,

Peter_Cammaert — Fri, 06 May 2016 18:35:20 GMT

If you put your sum() expression in a text box, does the outcome still change with every selection? If so, do as Sunny says and post an example document.

If not, then you're using dimensions that change the output. Chart dimensions are applied after the set is calculated. What other dimensions do you use in your chart, aside from Product?

Re: Hi everybody,

Kushal_Chawda — Sat, 07 May 2016 02:51:03 GMT

Expressions suggested above should work regardless of selection because there is a identifier 1 is used in expression.