Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

It's a difficult problem for me !!!!!!!!!!!!!!!!!!!

Hi friends! This is my first time in Qlikview Forum, so I am glad of being in the Qlikview family. I have a question as below:
I have a table of Sales as following:
Branch date Sales NO_OF_New_Customers
1 1/1/10 100,000 2
1 1/2/10 120,000 3
2 1/1/10 200,000 4
2 1/2/10 150,000 1
I want to have a pivot table that shows the total sales of a branch from the begining to a specific date (the date can be selected by user from a list box), but the number of new customers of that specific date (No Sum) like this:
Branch date Sales NO_OF_New_Customers
1 1/2/10 220,000 3
2 1/2/10 350,000 1
How can I have this Repot?
Thank you very much in advanced.

13 Replies
Not applicable
Author

NO,

Sorry, this is not my question.

I want the result as i explained in the example!

Not applicable
Author

hehehe.... u want a table that shows the sum of no of customers that if u click on june, then it shows the total from january that year until june the same year correct?

Not applicable
Author

Hi, i think this is what you need.

Hope it helps

Not applicable
Author

Thanks alot freind.

This is the exact thing that helps me.