topic Re: How to get value sum while choose one date? in QlikView

How to get value sum while choose one date?

Wed, 02 Sep 2015 03:53:07 GMT

Dear Master Qlik,

I have problem with sum, i have this table :

Date

Value

Stock

Sum

01/03/2014

100000

10.000

01/04/2014

150000

16.667

01/05/2014

200000

22.500

What i want is value in column sum, when i click Date 01/05/2014, then i will get the value of sum.

The process to get the value of Sum = Value in Date (01/01/2014,01/04/2014,01/03/2014) get summed(200.000+150.000+100.000) and then get divide with the value of stock in date 01/05/2014 : ((450.000/20) = 22.500).

Thanks for the help,

Re: How to get value sum while choose one date?

maxgro — Wed, 02 Sep 2015 18:13:10 GMT

try to add this expression

RangeSum(Above(sum(Value), 0, RowNo())) / sum(Stock)

Re: How to get value sum while choose one date?

Fri, 04 Sep 2015 06:40:43 GMT

Dear Massimo,

Your answer is really something, thanks very much.

But i have one little problem, if this date cross a year then the sum not working cos it's likely bound to a year.

would you mind to help me again ? Thanks before, i really appreciate your answer.

Kind regard's

Re: How to get value sum while choose one date?

sunny_talwar — Fri, 04 Sep 2015 06:53:38 GMT

I think if you provide a more comprehensive sample data, we might be able to help you better.

Best,

Sunny

Re: How to get value sum while choose one date?

Fri, 04 Sep 2015 07:03:01 GMT

Dear Mr. Sunny,

I'am sorry before but i think my problem was solved.

Thanks for your concern.

Regard's

Hadi

Re: How to get value sum while choose one date?

Fri, 04 Sep 2015 07:03:58 GMT

Dear All,

Thanks for the help, i really appreciate the care and attention from all the master qlik.

Regard's,

Hadi

Re: How to get value sum while choose one date?

sunny_talwar — Fri, 04 Sep 2015 07:30:32 GMT

Great and Sorry