Calculate Current Week - Previous Week Value

[#1]

I want to calculate Growth, which is equal to Current two weeks data minus previous two weeks data, how can I achieve the same?

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[Silambarasan1306]

previous two weeks means previous year two weeks..????

Explain the question clearly braj..

Thanks

[Anonymous]

For current two weeks

I am assuming current two weeks means next 2 weeks ?  (14 days)

=Sum({<DateField = {">=$(=Date(Today()+14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}} Growth)

Previous 2 weeks means  14 days ealier ?

=Sum({<DateField = {">=$(=Date(Today()-14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}} Growth)

or

like this ?

14 days ealier

=Sum({<DateField = {">=$(=Date(Today()-14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}} Growth)

28 days ealier

=Sum({<DateField = {">=$(=Date(Today()-28,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}} Growth)

????

Regards

Allu

[#5]

Thanks Allu, it worked.

But when I applied Date filter, it gave me different value. How should I ignore the date filter?

[Silambarasan1306]

Nullify the date in set analysis.

[Anonymous]

Hi

I am not sure about your query     : "How should I ignore the date filter?"

if you want the selection independent of SELECTION

14 days ealier

=Sum( 1 {<DateField = {">=$(=Date(Today()-14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}}Growth)

28 days ealier

=Sum( 1 {<DateField = {">=$(=Date(Today()-28,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}}Growth)

Will you post the sample qvw file , so that i can understand exact need ?

[#8]

Thanks Allu, it worked.

But when I replaced today with my column name, it gave me blank. The expression I implemented is as below:

Sum(  {<WEEK = {">=$(=Date([Latest Week]-14,'MM/DD/YYYY'))<=$(=Date([Latest Week],'MM/DD/YYYY'))"}} TOTALAMOUNT)

[Anonymous · Accepted solution]

Hi

what does 'Latest week' represents ?  week  ?

My set analysis is based on days  not  WEEK !!!

=Sum( 1 {<DateField = {">=$(=Date(Today()-14,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}}Growth)

Will you post the sample qvw file , so that i can understand exact need ?

Sum(  {<WEEK = {">=$(=Date([Latest Week]-14,'MM/DD/YYYY'))<=$(=Date([Latest Week],'MM/DD/YYYY'))"}} TOTALAMOUNT)

[#10]

Thanks a lot...