topic Re: select date to min date in QlikView

select date to min date

kunkumnaveen — Tue, 12 Jul 2016 11:57:58 GMT

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

MindaugasBacius — Tue, 12 Jul 2016 12:10:06 GMT

Try this:

sum({group1<date={">=$(=vmin)<=$(=vmax)"}>}value)

kunkumnaveen — Tue, 12 Jul 2016 12:17:25 GMT

thanks for ur reply ,

but its not working bro....

MindaugasBacius — Tue, 12 Jul 2016 12:21:56 GMT

sum({<date={">=$(=vmin)<=$(=vmax)"}>}value)

What about when removing group1?

ramoncova06 — Tue, 12 Jul 2016 14:31:43 GMT

remove the equal sign "=" from the variable you can change the expresion to

sum({group1<date={">=$(=vmin)<=$(=vmax)"}>}value)

kunkumnaveen — Wed, 13 Jul 2016 06:32:18 GMT

still looking for suggestions

MindaugasBacius — Wed, 13 Jul 2016 06:33:44 GMT

Could you please attach qvw?

kunkumnaveen — Wed, 13 Jul 2016 06:47:03 GMT

Hi,

plz find attachment with sample data,

Note:i want it to be work by applying groups only

thanks