Discussion Board for collaboration related to QlikView App Development.
I have some dimensions and one of it is date. Also I have a few volumes for each date. I need to get sum of volumes, for which date less then in dimension.
Dim 1, Dim 2, Date, volume, sum of volumes less date
A, AA,. 6,. 15,. 0
A,. AB,. 7,. 5, 30
B,. BA,. 6,. 15,. 0
B,. BB,. 8,. 10,. 35
I can't understand how to compare dates for each row with date in dimension and get sum.
Describe more? How date is Less than The number??
The date is month number. For example, I get 0 in first raw, because I haven't observation with date less 6, I get 30 in second raw, because I have two observations with date less 7.(15+15)
Not sure, Still i followed you. What this returns?
If(Date < volume, Sum(volume))
Can you explain little in technical.. I believe you may need Above() and Below()
I'm not sure, because I need universal design.I mean, I need compare all dates with date in dimension. And after that I sum volumes, for which dates satisfy the condition.And I need do it for all raws.
NP, Anyway he may offer you vinieme12