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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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