Using Qlikview 12, I have an macro that runs and makes two selections.
1. Select Placement Name and Lock it.
2. Select the Next Wednesday Date
3. Export data from chart.
The problem I'm running into is that there are times when the two selections are mutually exclusive. So there are no transactions for the "Next Wednesday Date" sometimes.
The problem is that Qlik will just not make that Date selection and thus my export has a bunch of dates, but what I really want in that situation is NO data to be exported.
Am I missing a simple setting to allow this?
Here is my sample selection macro code:
sub export
call ClearDoc
ActiveDocument.Fields("PlacementName").Select "placement one"
ActiveDocument.Fields("PlacementName").ToggleSelect "placement two"
ActiveDocument.Fields("PlacementName").Lock
ActiveDocument.Fields("InsertCalendarDate").Select
ActiveDocument.Evaluate("=Date(Today()+7)")
call AML_PrintToExcel("vExportLocation", "ExportChart", "", "","CWH")
end sub
