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

[#1]

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.

[#2 · Accepted solution]

you make pivot table

take pivot chat

dimension

Branch and date.

Expression

sum(Sales) and sum(NO_OF_New_Customers).

Regards

Ashish

[#3]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1122.example.rar:550:0]

Hope this will help you.

Regards

[#4]

No

I want sum of Sales but the NoOf_new_customer of the selected date not the sum.

[#5]

Non of your sugestions are correct

[Miguel_Angel_Baeyens]

Then use "NoOf_new_customer" as expression, in case just one value is possible.

[#7]

You mean I can not have this report in Qlikview?????????

[#8]

Is that what you want to do?

[#9]

Its not correct.

when I click the date, I want to have sum of sales from the begining not only the sum of the selected date.

[#10]

Hope this solves your problem.....!