Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Usually, To calculate MTD we are working like
=count({$<campaign_id={"service","technology"},user_group ={"Tel"}, DateField={">=$(=MonthStart(Max(DateField)))<=$(=Max(DateField))"}>}phone_number)
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
Usually, To calculate MTD we are working like
=count({$<campaign_id={"service","technology"},user_group ={"Tel"}, DateField={">=$(=MonthStart(Max(DateField)))<=$(=Max(DateField))"}>}phone_number)
Thank very much for your help
It doesn't work.
Why?
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.
Please post some more information to get into work ?
Do you need acuumulation here?
please post some sample data to work upon
Hi All
Please receive attached.thank you very much for help
Thanks
Hi Anil
I have attached more information please check.
Thanks