How to create a summary page dynamically

[#1]

Hello Guru's,  I have a problem, the scenorio is there is a report find the total number of invoices and sum of sales on daily basis.  I would like to create a dynamic summary in a separte sheet the format is as follows, if I run the Qvd the values will be changed in a daily basis automatically.  How to do this....  Total Number of Invoices for today 300 Invoices.  Sum of sales today $ 520 855.  Thanks in advance.

[kaushiknsolanki]

Hi

     You can use replace load.

     For example

     Replace Load A, B, C from ABC where Date = Today();

     So everytime you reload the application it will show you the current day data.

     But in this case your previous data will be lost, cause it has been replaced with new one.

Regards,

Kaushik Solanki

[#3]

Hi,

Thanks for your reply, I need the following requirements to be solved.

Header 1	Header 2
Coke	1000
Pepsi	2000
Total Sales	3000

the values are in a stright table, the values are all change everyday, I want a summary sheet to display like below .

Coke 1000

Pepsi 2000

Sales 3000

Regards

Joe

[kaushiknsolanki]

Hi,

    Can you Please send me the QVW file with sample data.

Regards,

Kaushik Solanki

[#5]

Hello Kaushik,

I have attached the sample of my requirement. its in my orginal post.

Requirement is :

1. When I reload the qlikview file the what are the value's availble in the main sheet it should reflect in the summary page.

2. I have used text box in the summary page, but I need the dynamic concept when the value changed in the main sheet.

Hope its clear for you.

Thanks a lot

Joe

[kaushiknsolanki · Accepted solution]

Hi

    I am uploading a sample file. Have a look at this

Regards,

Kaushik Solanki

[#7]

Dear Kaushik,

It works, thanks for your help.

Regards

Joe