topic Re: MTD in QlikView

MTD

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

Hi All

I have below working function which calculate current call offered per day,what i am struggling is to calculate MTD call offered please help?

=count({$<campaign_id={"service","technology"},user_group ={"Tel"}>}phone_number)

Thanks

Re: MTD

jonathandienst — Mon, 15 Jan 2018 11:26:25 GMT

Its impossible to provide anything other than the most general advice without any knowledge of the data model, how you would like to use the expression and any other detail. I suggest that you take some advice from the following:

Qlik Community Tip: Posting Successful Discussion Threads

Qlik Community Tip: How to Get Answers to Your Post

Preparing examples for Upload - Reduction and Data Scrambling

Re: MTD

Anil_Babu_Samineni — Mon, 15 Jan 2018 11:28:51 GMT

Usually, To calculate MTD we are working like

=count({$<campaign_id={"service","technology"},user_group ={"Tel"}, DateField={">=$(=MonthStart(Max(DateField)))<=$(=Max(DateField))"}>}phone_number)

Re: MTD

mandilicious — Tue, 16 Jan 2018 07:30:27 GMT

Thank very much for your help

It doesn't work.

Re: MTD

Anil_Babu_Samineni — Tue, 16 Jan 2018 08:20:33 GMT

Why?

Re: MTD

mandilicious — Tue, 23 Jan 2018 07:40:11 GMT

Hi Anil,

Please help actually i have realized that we dont have MTD data we need to store or create table using day to day totals calls received for MTD value.

E.g If totals calls received = 100 for Monday we need to store that value.

Monday or Date(22/01/2018) = 100 calls

Tuesday or Date(23/01/2018)= 200 calls

Then our totals MTD should be 300 calls received.

I hope it make sense.

Re: MTD

Anil_Babu_Samineni — Tue, 23 Jan 2018 10:11:17 GMT

Please post some more information to get into work ?

Re: MTD

shiveshsingh — Tue, 23 Jan 2018 10:45:50 GMT

Do you need acuumulation here?

please post some sample data to work upon

Re: MTD

mandilicious — Thu, 25 Jan 2018 15:40:28 GMT

Hi All

Please receive attached.thank you very much for help

Thanks

Re: MTD

mandilicious — Fri, 26 Jan 2018 13:08:56 GMT

Hi Anil

I have attached more information please check.

Thanks

Re: MTD

mandilicious — Fri, 26 Jan 2018 13:10:06 GMT

Hi Shivesh

I have Attached data as requested.

Thanks