Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

select date to min date

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

7 Replies
Highlighted
Specialist III
Specialist III

Try this:

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

thanks for ur reply ,

but its not working bro....

Highlighted
Specialist III
Specialist III

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

What about when removing group1?

Highlighted
Specialist III
Specialist III

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

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

Highlighted
Specialist
Specialist

still looking for suggestions

Highlighted
Specialist III
Specialist III

Could you please attach qvw?

Highlighted
Specialist
Specialist

Hi,

plz find attachment with sample data,

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

thanks