topic Re: Getting same count on YTD and MTD in QlikView

Getting same count on YTD and MTD

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am getting same count on YTD and MTD.I have added the sample file please help me to resolve the issue.

Thanks

Re: Getting same count on YTD and MTD

ajsjoshua — Wed, 15 Jun 2016 05:08:09 GMT

Hi,

Whats ur expression.

Re: Getting same count on YTD and MTD

bhavvibudagam — Wed, 15 Jun 2016 05:21:58 GMT

Hi,

These are the expression i have used for YTD and MTD

='YTD = ' & Count({<Year=, Month=, Quarter=, Week=, Date= {">=$(=Num(YearStart(max(Date)))) <=$(=max(Date))"}, CALL_SOUR={'ANI/ALI','PHONE','WALK-IN'}>}NUM_1)

='MTD = ' & Count({<Year=, Month=, Quarter=, Week=, Date= {">=$(=Num(MonthStart(max(Date)))) <=$(=max(Date))"}, CALL_SOUR={'ANI/ALI','PHONE','WALK-IN'}>}NUM_1)

Re: Getting same count on YTD and MTD

MayilVahanan — Wed, 15 Jun 2016 05:33:04 GMT

Try like this

='MTD = ' & Count({<Year=, Month=, Quarter=, Week=, Date= {">=$(=Date(MonthStart(max(Date)),'DD-MM-YYYY')) <=$(=Date(max(Date),'DD-MM-YYYY'))"}, CALL_SOUR={'ANI/ALI','PHONE','WALK-IN'}>}NUM_1)

='YTD = ' & Count({<Year=, Month=, Quarter=, Week=, Date= {">=$(=Date(YearStart(max(Date)),'DD-MM-YYYY')) <=$(=Date(max(Date),'DD-MM-YYYY'))"}, CALL_SOUR={'ANI/ALI','PHONE','WALK-IN'}>}NUM_1)

Re: Getting same count on YTD and MTD

bhavvibudagam — Wed, 15 Jun 2016 06:07:35 GMT

Hi mayli thank for your reply

It's not working. both the expression initially showing 0.After date selection they are showing values same as my above expression values.

Re: Getting same count on YTD and MTD

MayilVahanan — Wed, 15 Jun 2016 06:10:48 GMT

Please find attached file

Initially zero, because for 2016, there is no below values in Cal_Sour.

ANI/ALI

PHONE

WALK-IN

Re: Getting same count on YTD and MTD

maniram23 — Wed, 15 Jun 2016 06:24:02 GMT

Hi,

IN CALL_SOUR what are the data you selected . That data is not there in your 2014th year .

That so your getting "0" value. Just you can make selection on before Year and any month. Than you will get exact output.

If you know the excel. just tell me how much your getting on 2013th YTD and MTD of 2013th DEC.