Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Calculate the Sum

Hello,

i have 3 dates and 3 values. now i want the sum of those values, which are in the interval of 7 weeks of the date.

my example shows it.

DateValue
16.04.201326,84
17.05.201348,81
19.06.2013706,42

7 weeks before 19.6 is only 17.05.2013. So i want the sum of 706,42 and 48.81.

How can i make this? With a if-statement or loop?

Thanks for your  help!

Best regards,

Aylin

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

If you make a date from your Date field you can use set analysis expressions. See attached example.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

If you make a date from your Date field you can use set analysis expressions. See attached example.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Thank you very much Gysbert!

Highlighted
Not applicable

Thank you very much Gysbert!

Highlighted
Not applicable

Thank you very much Gysbert!

Highlighted
Not applicable

Thank you very much!