Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

oseimuduame
Contributor

Counting Created Customer Per Month

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.

Tags (1)
16 Replies
MVP
MVP

Re: Counting Created Customer Per Month

Can you try like this:


Dimesion: BRANCH NAME and MONTHYEAR

Expression: Count(DISTINCT CUST_ID)

oseimuduame
Contributor

Re: Counting Created Customer Per Month

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

MVP
MVP

Re: Counting Created Customer Per Month

May be this to fix the partial sums

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

oseimuduame
Contributor

Re: Counting Created Customer Per Month

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.

changing values.png

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

changing values2.png

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

changing values3.png

Please any help?

Thank you for sharing your knowledge Sunny T...

oseimuduame
Contributor

Re: Counting Created Customer Per Month

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

MVP
MVP

Re: Counting Created Customer Per Month

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
Contributor

Re: Counting Created Customer Per Month

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

MVP
MVP

Re: Counting Created Customer Per Month

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
Contributor

Re: Counting Created Customer Per Month

check out the two images i will be sending  now

changing values2.pngchanging values3.png