topic Re: Store Current Selections to QVD in QlikView

Store Current Selections to QVD

Tue, 13 May 2014 03:39:02 GMT

Dear Experts,

I have this requirement:

1. I have two filters Year and Brand.

2. I have a pivot table with few rows as inputfields.

3. I select a particular year and a brand.

4. I enter a estimated sales for the above selected filter criteria in the inputfields of the pivot table.

5. I click on a button in the dashboard.

6. The data in the pivot table along with the current selections of the filter should get saved into the QVD.

7. Later I should be able to read them from the QVD.

Would it be possible to implement this scenario?

Please kindly help.

Thank you.

Re: Store Current Selections to QVD

Anonymous — Tue, 13 May 2014 04:01:43 GMT

Why not you use a macro to export the data to qvd.

and call this macro on click of your button.

For current selections , you can even export them easily via macro.

Regards

Nitin

Re: Store Current Selections to QVD

Tue, 13 May 2014 04:41:26 GMT

Thank you Nithin.

I have one more question... Does the macros run in webview mode/server side?

Re: Store Current Selections to QVD

Anonymous — Tue, 13 May 2014 05:05:33 GMT

Yes macros will work fine in IE or webview,

but they have issues in execution in other browsers i.e. with ajax client.

Re: Store Current Selections to QVD

Tue, 13 May 2014 05:21:22 GMT

But the macro that I have written is not working in the webview...

I have written a macro to store the pivot table into QVD in particular location system... Say C:\Test\table.qvd.

This works fine in normal mode... the qvd is created in the location.. but in webview it is not getting created. Should I do some additional settings.?