topic Re: script module with if condition of a data loading field in QlikView

script module with if condition of a data loading field

geogou1973 — Fri, 21 Mar 2014 09:01:18 GMT

Hello.

I have a script module in a trigger on post reload action that exports an excel file from a chart.

The script is :

Sub ExportFiles

pathcorp="c:\sales\"

set corp = ActiveDocument.GetSheetObject("CH01")

corp.ExportBiff pathcorp & "Sales.xls"

End Sub

The dimension of the chart is the field "store" and the expression is

sum ( { <date_id = { '$(=vdate)' } > } sales )

The date_id and sales are fields and vdate is a variable that returns the current date.

My issue is how can i export from a script module the data for all the stores i have .

What changes have to do in the script and the expression of the chart.

Thank you in advance

alexandros17 — Fri, 21 Mar 2014 09:05:12 GMT

if you need to see all the rows (and export from the chart) add as dimension the date_id field ...

geogou1973 — Fri, 21 Mar 2014 09:12:18 GMT

I don't understand what you tell me.

I want from this one chart to export data that concern each store, by store with the script module.

Let's say Store_101.xls ,Store_102.xls