QlikView App Dev

[shweta2608]

How to calculate the values of order which are due in the next 90 days.

[karunpreet]

Hi Shweta,

Can you please elaborate your concern.

According to my understanding of your requirement,

To calculate the values of orders which are due in the next 90 days,

LET vNow = Date(Floor(ReloadTime()));

LET vNowPlus90 = Date(Floor(Num(ReloadTime()) + 90)) ;

sum({<[Target Date]={">$(vNow)<$(vNowPlus90)"}>}Orders);

Please do let me know for any concern on the same.

Regards

Karunpreet

[vinieme12]

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling