Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
i need help in writing down a expression to get values b/w min date to current selected in comparative analysis,
let say if i got a sample data like this:
date value
1 jan 100
2 jan 200
3 jan 300
4 jan 400
from a calendar object(which is under group1) if i select 4 jan then i should get sum of values from 1 jan to 4 jan (100+200+300+400),
if 3 jan then 1 jan to 3 jan(100+200+300)..
for this the variable i had written :
vmin='1 jan';
vmax=max({group1}date).....i tested it in a textbox ,if i use this=$(vmax),it throwing me error ,then if i use this=vmax i am getting value
then i wrote expression like
sum({group1<date={">=$(vmin)<=$(vmax)"}>}value) (which is not working)
plz any suggestions
Try this:
sum({group1<date={">=$(=vmin)<=$(=vmax)"}>}value)
thanks for ur reply ,
but its not working bro....
sum({<date={">=$(=vmin)<=$(=vmax)"}>}value)
What about when removing group1?
remove the equal sign "=" from the variable you can change the expresion to
sum({group1<date={">=$(=vmin)<=$(=vmax)"}>}value)
still looking for suggestions
Could you please attach qvw?
Hi,
plz find attachment with sample data,
Note:i want it to be work by applying groups only
thanks