topic Sum previous quantity vs selected date in QlikView

Sum previous quantity vs selected date

Wed, 16 Nov 2011 11:58:26 GMT

Hi to all I'm a new QV user and I have a problem to sum some values...

Here my problem, I need to sum values where the data is smaller the the select data:

For example:

I have 4 column

Data

Month

Sum previous quantity vs selected date

SunilChauhan — Wed, 16 Nov 2011 12:12:34 GMT

use below code

sum({$<Mese = {"<=$(=Mese)"}>} Quantita)

hope this helps

Sum previous quantity vs selected date

Wed, 16 Nov 2011 22:03:31 GMT

unfortunately it doesn't work, the problem is that I need to sum all the values where the date is smaller then the selected date. if I use = is not correct, would be < but I think that can't use logic operator in this kind of string.....

If I insert the code in my test file (attached) the result is 30 instead 26 futhermore if I select some days it dosen't work

...any other idea ?

thx in advance

Sabina

Sum previous quantity vs selected date

Wed, 16 Nov 2011 23:04:46 GMT

You'll need to convert the Date into Date in your script and then use it in the set analysis. As far as using Months is concerned: you can try: Sum({$<Mese = {'<=$(=max(Mese))'}>}Quantita)

Sum previous quantity vs selected date

Wed, 16 Nov 2011 23:51:14 GMT

I have already found a part of the solution...I mean If I use this

Sum({$<[Data] = {"<=$(=Date(num(min(Data))-1))"}>} Quantita)

when I select some values in the Data field, it's work corectly...

but If I select month or year the previus code doesn't work... the problem is that I don't know which fields the user want to use...

Thx again

Sabina