topic Re: QTD sales in QlikView

QTD sales

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I worked on calculating YTD MTD sales bith are works fine.But while calculating QTD on the same way not working properly.

Below are for your reference.

YTD >>>

Sum({<doj={'>=$(=YearStart(Today()))<=$(=Today())'}>}pkg)

MTD>>>

Sum({<doj={'>=$(=MonthStart(Today()))<=$(=Today())'}>}pkg)

QTD

Sum({<month={'>=$(=QuarterStart(Today())<=$(=Today())'}>}pkg)

Please suggest on this.

Re: QTD sales

sunny_talwar — Wed, 18 May 2016 18:26:21 GMT

Why did you change QTD to check on month? try with doj and should work:

Sum({<doj={'>=$(=QuarterStart(Today())<=$(=Today())'}>}pkg)

Re: QTD sales

Thu, 19 May 2016 03:22:32 GMT

Yes sunny also I tried with doj but didn't work.

Please help!

Re: QTD sales

jagan — Thu, 19 May 2016 03:51:15 GMT

Hi,

Try like this

YTD >>>

Sum({<month=, year=, quarter=, doj={'>=$(=YearStart(Today()))<=$(=Today())'}>}pkg)

MTD>>>

Sum({<month=, year=, quarter=, doj={'>=$(=MonthStart(Today()))<=$(=Today())'}>}pkg)

QTD

Sum({<month=, year=, quarter=, doj={'>=$(=QuarterStart(Today())<=$(=Today())'}>}pkg)

month=, year=, quarter= ignores the selections in this fields, so you always get the YTD, MTD and QTD values.

Check this links hope it helps you.

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Regards,

Jagan.

Re: QTD sales

Thu, 19 May 2016 06:05:11 GMT

Hi Jagan,

Thanks for your attachments very helpful.

Still am working on the same but no accurate result.

Please have a look at above attachments.

I don't know exactly where am wrong.

Kindly suggest on this.

Re: QTD sales

Thu, 19 May 2016 06:25:22 GMT

Now I got it.

Thank you !!!!!

Re: QTD sales

sunny_talwar — Thu, 19 May 2016 13:10:54 GMT

Close the thread if it is all working now

Best,

Sunny