topic Re: Problem Sum in QlikView

Problem Sum

Mon, 01 Feb 2016 10:19:47 GMT

Hi,

I have a problem with Function "Sum"

I try to calculate "Stock UC a date" with this :

FirstSortedValue(aggr(DISTINCT Sum(Qte_UC_Stock_BDD)+ sum(Qte_PCU_STOJOU),Date_Mvt, Code_Article,Stat_2_Article),-aggr(Date_Mvt,Date_Mvt,Code_Article,Stat_2_Article ))

and

FirstSortedValue(aggr(DISTINCT Sum(Qte_UC_Stock_BDD)+ rangesum(Above(TOTAL (Sum(Qte_PCU_STOJOU)) , 0, RowNo())),Date_Mvt, Code_Article,Stat_2_Article),-aggr(Date_Mvt,Date_Mvt,Code_Article,Stat_2_Article ))

It's Ok for collapse or expand but my results is not good.

Normally subtract every operation of movement of the result obtained previously on "Stock UC a date"

Maybe anyone have an idea where is my problem?

Re: Problem Sum

jolivares — Mon, 01 Feb 2016 14:21:47 GMT

Try to post a small sample with data and show what is your problem better, i can't see what is happening or what you really want.

Let me help you.

Re: Problem Sum

Mon, 01 Feb 2016 14:51:18 GMT

a demo with my problem

Best regards

Re: Problem Sum

Mon, 01 Feb 2016 16:02:15 GMT

i join a demo for explain my problem

Best regards

Re: Problem Sum

Tue, 02 Feb 2016 16:06:47 GMT

anyone can help me ?

Re: Problem Sum

jolivares — Tue, 02 Feb 2016 16:36:15 GMT

You need to user dimensionality()

If(Dimensionality()>4,(Sum(StockAnterieur))+ rangesum(Above(TOTAL (Sum(Q_Mvt)) , 0, RowNo())),

FirstSortedValue(aggr(DISTINCT Sum(StockAnterieur)+ sum(Q_Mvt),Date_Mvt, Code_Article,Stat_2_Article),-aggr(Date_Mvt,Date_Mvt,Code_Article,Stat_2_Article )))

Re: Problem Sum

jolivares — Tue, 02 Feb 2016 19:05:27 GMT

Ups... I think this is the solution to your question.

Re: Problem Sum

Wed, 03 Feb 2016 07:01:56 GMT

Hello,

Nor working, i have the same results.

when i expand my board on "date_Mvt" i found 1520 in QTY and is the good results;

but when i collapse to "Code_Article" or "Stat_2_Article" my results is not good i found 1910..

Thanks to the help

Re: Problem Sum

jolivares — Wed, 03 Feb 2016 19:18:14 GMT

Ok... Pascal, see the example below. I just simply yours.

This is what you are looking for:

Re: Problem Sum

jolivares — Wed, 03 Feb 2016 19:19:10 GMT

I forget attach the sample QVW

Re: Problem Sum

Thu, 04 Feb 2016 06:44:32 GMT

Thanks a lot Juan it's work perfectly

Best regards