Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
geogou1973
New Contributor II

script module with if condition of a data loading field

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

2 Replies

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

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

geogou1973
New Contributor II

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

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 

Community Browser