Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD MTD

Hi to all,

=num((sum({<BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)
-
(sum({<BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)
-
(sum({<BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag),'##.00')

Label name:Gross Weight

I have this expression, I want Calculate YTD,MTD&WTD, how can i do that please help me

Thanks in Advance.

chandra

Labels (1)
2 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

pls check the below link

YTQ, QTD, MTD and WTD

Not applicable
Author

Hi Manoj,

where Can i write please give me Navigation

Thanks for your reply