YTD MTD

[#1]

Hi to all,

(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)

I taken label name as " Gross Weight" for above expression...please help me

I want find out YTD,MTD& WTD for above Expression.

How can I do???

Please help me out this issue.

Thanks in Advance.

regards

Chandra.

[jagan]

Hi,

Did you changed MonthStart and WeekStart() in your expressions

MTD:

(sum({<Date={'>=$(=MonthStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=MonthStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=MonthStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

WTD:

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

If not working attach some sample file.

Regards,

Jagan.

[#3]

Hi Jagan,

I am getting Values for Ytd and Mtd also...

I will try for that anyway i am very thankful to you...

thanks.

Regards

Chandra.

[jagan]

Hi,

Please close this thread by giving Correct and Helpful answers to the useful posts, so that it would be helpful for others who are looking for similar solutions.

Go through the Set Analysis topic in Qlikview Help file (F1), so that you can understand this type of expressions easily.

Regards,

Jagan.

[#5]

Hi Jagan,

I am very thankful to your replies.

Sorry for the delay.

As you said i closed this

Many thanks to you

Regards

Chandra.

[jagan]

Hi

Close this thread by clicking Correct Answer and Helpful Answers buttons to the useful posts.

Regards,

jagan.

[#7]

Hi Jagan,

Can you please give me that WTD expression

Please help me

[jagan]

WTD:

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

-

(sum({<Date={'>=$(=WeekStart(Today()))<=$(=Today())'}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}>}BILLDETAILGROSSWEIGHT)/WeightFlag)

Regards,

Jagan

[#9]

Hi Jagan,

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

in App Development • Share • Reply • Like Show 0 Likes(0)

Hide full preview

Mark unreadHide new activity

0 replies

Reply to original discussion

[jagan]

=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')

[#11]

Hi Jagan,

Thanks for your reply.

For above Expression is working like my expression.

But I want " Without any selection I have to display the value for current WTD ( February) in Text Box.

I displayed Values with Selection that part I done.

Please help me out from this issue.

Regards.

Prathap.