Subtotal Field A at change of Field B

[Anonymous]

Hi all,

In a straight table chart, I have one column displaying Sales Order No (s_order) and another column displaying the Sales order Total Inc (order_total).

I need to display a subtotal for "order_total" at every change of "s_order".

can anyone direct me on how to achieve this?

Thanks in Advance!!

F.Giorgio

[rahulpawarb]

Hello Fabrizio,

Trust that you are doing well!

Could you please share the application with sample data? This will help us to provide you desired result.

Regards!

Rahul

[Anonymous]

Hi Rahul,

I would gladly do that if only I knew how to save the data without needing the script to poplulate the chart.

what is the best way to achieve that?

sorry I'm quite new to qlikview...

Fab..

[rahulpawarb]

Hello Fabrizio,

Thank you for swift response.

You can prepare QVD file to share sample data using below code snippet:

STORE Data INTO C:\Test\Data.qvd(qvd);

You can share the generated QVD file for our reference.

P.S.: You should have Data Table loaded before this statement as well as Test folder must be there on C: drive.

Regards!

Rahul

[Anonymous]

Hi Rahul,

Thanks again for your input...

Just trying to do this for you...

It seems that when running:

STORE Data INTO C:\Test\Data.qvd(qvd);

Qlikview tries to store a .QVD table with the name "Data" in C:\Test\ if I am understanding this correctly.

I have 4 Tables as per below:

I tried to run:

STORE SBCDebtor INTO C:\Qlikview\Testing\SBCDebtor.qvd(qvd);

STORE SBCSOrder INTO C:\Qlikview\Testing\SBCSorder.qvd(qvd);

STORE SBCSOrdline INTO C:\Qlikview\Testing\SBCSOrdline.qvd(qvd);

STORE SBCProduct INTO C:\Qlikview\Testing\SBCProduct.qvd(qvd);

However this does not work...

Should I just rewrite my script to populate just 1 table for testing purposes?

Or is there a better way to do this when multiple tables are present?

Thanks again and sorry for my inexperience with this...

Fab

[rahulpawarb]

Hello Fabrizio,

Yes your approach is correct! However, you can try with one table if gets successful then you can apply the same to all the tables. Make sure that you have STORE statement at end of script.

BTW, you can share your application.

Thank you!

Rahul

[Anonymous]

Hi Rahul,

thanks again for your input.

I have saved the QVD files, however my script points to our ODBC database...

How is the data going to load for you via the QVD files? should I be editing the script for you?

and how would i share this to you? Via a .ZIP folder?

Also - how do I share my application?

Once again - every step is a discovery for me at the moment so I appreciate your patience...

Thanks again...

Fab

[rahulpawarb]

Hello Fabrizio,

I will modify the existing script to load data from QVD files. You can share the QVDs via a .ZIP file. To Attach files (application + QVDs) you can select Use Advanced Editor option present at top right corner and then select Attach option at the bottom right corner (refer attached screenshot).

Hope this will help.

Regards!

Rahul

[Anonymous]

Hi Rahul,

I have saved my application (qvw) and sample data as an xls.

I have zipped both these files into a folder called Test.zip (unzip it to C:\Test and the script will work)

This will simplify things for you as you will not need to modify the script...

However when I go to Create > Uploaded file to upload the zip file to this forum I'm not sure where to upload it to.

Can you let me know?

Thanks again for your help...

Fab

[rahulpawarb]

Hello Fabrizio,

While replying on this thread, you can choose an Use Advanced Editor option and attach the required files (refer screenshot attached in the earlier thread.

Regards!

Rahul

[Anonymous]

Hi Rahul,

I've worked it out...

I was replying to you and when I do that, the advanced Editor option is not available...

it's only available when replying to the thread asd opposed to your latest comment.

I have now attached the zip file...

save it to your C drive and you should be able to load the data via the spreadsheet in the zip file...

once again, i'm after a subtotal for BOrders Total inc and InPicking Total inc at each change in S/Order number

Hope that that's clear...

Thanks again for your help...

Fab