topic How to create a summary page dynamically in QlikView

How to create a summary page dynamically

Thu, 19 May 2011 07:26:49 GMT

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.

How to create a summary page dynamically

kaushiknsolanki — Thu, 19 May 2011 07:33:10 GMT

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

Re: How to create a summary page dynamically

Thu, 19 May 2011 09:06:42 GMT

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

Re: How to create a summary page dynamically

kaushiknsolanki — Thu, 19 May 2011 09:52:24 GMT

Hi,

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

Regards,

Kaushik Solanki

How to create a summary page dynamically

Thu, 19 May 2011 10:35:51 GMT

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

Re: How to create a summary page dynamically

kaushiknsolanki — Thu, 19 May 2011 10:48:49 GMT

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

Regards,

Kaushik Solanki

How to create a summary page dynamically

Thu, 19 May 2011 11:22:44 GMT

Dear Kaushik,

It works, thanks for your help.

Regards

Joe