Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

WTD

Hi to All,

For following expression i want get the WTD value in Text Object.

I am getting the values if i select.

But without Selection i want get the Present Month Week to date value in the sense feb month

i have the date field from  Apr/01/2014 to Mar/01/2015.

But i have the data from Apr/01/2015 to Feb/05/2015.

How Can i get this please help me out this issue.

Following is my expression.

=Num((sum({<Year=, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Year=, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Year =, Quarter=, Month=, Week=, [BILL DATE]=,BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE)-1)))<=$(=Date(Max(BILLDATE)))"}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag),'##.00')

Thanks in Advance.

Regards

Chandra

0 Replies