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.
thanks for your reply
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
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...
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