Counting Created Customer Per Month

[oseimuduame]

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.

[sunny_talwar]

Can you try like this:

Dimesion: BRANCH NAME and MONTHYEAR

Expression: Count(DISTINCT CUST_ID)

[oseimuduame]

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...

[sunny_talwar]

May be this to fix the partial sums

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

[oseimuduame]

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...

[oseimuduame]

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

[sunny_talwar]

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

[oseimuduame]

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

[sunny_talwar]

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

Count(DISTINCT CUST_ID)

[oseimuduame]

check out the two images i will be sending  now