topic Re: Counting Created Customer Per Month in App Development

Counting Created Customer Per Month

oseimuduame — Sat, 04 Jun 2016 13:59:07 GMT

Good Afternoon,

pls i am new to Qlikview and i have some reports running very well, but my boss requested for a reprot that will display the total number of created customers per month based on branch.

i have a field in my table that holds Customer Created Date = CUST_CREATE_DATE

I tried but all i am getting is an empty table.

I have Branch name and Month as my Dimensions and my Expression goes below;

if(CUST_CREATED_DATE = today(), count(CUST_ID))

I want the report to be on a pivot table having BRANCH NAME on my left, Month at the TOP and the Counts under each Month and Branch respectively.

Any help Please.

Re: Counting Created Customer Per Month

sunny_talwar — Sat, 04 Jun 2016 19:04:13 GMT

Can you try like this:

Dimesion: BRANCH NAME and MONTHYEAR

Expression: Count(DISTINCT CUST_ID)

Re: Counting Created Customer Per Month

oseimuduame — Tue, 07 Jun 2016 07:18:38 GMT

thanks for your reply

I tried

Dimesion: BRANCH NAME and MONTHYEAR

Expression: Count(DISTINCT CUST_ID)

and it worked but using partial sum in PIVOT table is not summing up my total correctly

any help...

Re: Counting Created Customer Per Month

sunny_talwar — Tue, 07 Jun 2016 09:43:46 GMT

May be this to fix the partial sums

Sum(Aggr(Count(DISTINCT CUST_ID), [BRANCH NAME], [MONTHYEAR]))

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 16:54:59 GMT

Thank youso much.

its working perfectly now but is still have a little issue....

At default the object (PIVOT Table) gives me summary of what my expression is but if i filter the VALUES are changing?

See picture below.

that is my default launch.... but the picture below is what i got after qpplying filter which is not correct.

this is the filter for Customer Created for the year 2016....

while the next image is filter for Customer Created for Year 2016 and Month JUNE

Please any help?

Thank you for sharing your knowledge Sunny T...

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 16:56:13 GMT

I believe these three values should be Equal not getting different values for different Filter

Re: Counting Created Customer Per Month

sunny_talwar — Fri, 10 Jun 2016 17:11:45 GMT

Are you saying that value for 2016 June should be the same or do you want this chart to not filter based on selections?

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 17:22:30 GMT

i would love you to check the total for JUNE 2016 Selection and Ordinary 2016.

i believe that since June is in 2016 then Filtering for JUNE 2016 should be equal to June When you filter for 2016

Re: Counting Created Customer Per Month

sunny_talwar — Fri, 10 Jun 2016 17:25:34 GMT

Ignoring the totals for right now, do you get the same number when you filter if you use this expression:

Count(DISTINCT CUST_ID)

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 17:26:44 GMT

check out the two images i will be sending now

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 17:29:22 GMT

When Filtering for 2016, June is 95 but when you flioter for 2016 June you have 67. Thats what i am saying

Re: Counting Created Customer Per Month

sunny_talwar — Fri, 10 Jun 2016 17:34:46 GMT

I understand what you are saying. What I am asking is for you to check if you still see the same result when you use this expression -> Count(DISTINCT CUST_ID)

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 17:38:40 GMT

Yes i am getting the same values.

Re: Counting Created Customer Per Month

sunny_talwar — Fri, 10 Jun 2016 17:54:28 GMT

Will it be possible to share the application to take a look at it? If confidentiality or size is an issue, you can look here:

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Counting Created Customer Per Month

oseimuduame — Fri, 10 Jun 2016 18:07:01 GMT

i am connecting my application to an oracle data source. how will you be able to get the Data Source

Re: Counting Created Customer Per Month

sunny_talwar — Fri, 10 Jun 2016 18:48:30 GMT

If you have already reloaded the data, I will get the data stored within the application

Re: Counting Created Customer Per Month

swuehl — Fri, 10 Jun 2016 21:42:23 GMT

Which exact dimension fields are you using in your chart?

Just wondering if you are using different fields than you are using for selection.

Your Month in the chart shows textual values, while your list box you are making the creation month selection is shows a number.

If you are using different fields, how are these related to each other?