I recently completed the QlikView Designer and Developer course and took over our companies dashboard that was built by a previous employee. Currently, we run scripts in SAP, download the results as Excel files then upload the excel files into a folder that is pulled by Qlik. Some of them are pulled directly from the folder to the Dashboard others are first ran through a QVD generator.
I cannot get our invoice information into the Dashboard. The invoicing table is run through the QVD generator and is turned into a billing table. One text box in the dashboard reads the last invoice date, 2/9/16, the correct date. The Invoice date comes from the Billing table that is a QVD. But the sales for Feb MTD are $0, which is incorrect but also comes from the Billing QVD that is feed by the invoicing excel file that is pulled from SAP. The text for the text box that is reading $0 is "=num(sum($(vSetBillMTD) [BillValue.USD]), '$#,##0')". I cannot find where the vSetBillMTD Variable is initialized, I went through the scripts and couldn't find it. The code for the text box that correctly reads the most recent invoice date reads "='Last Invoice Date: ' & max(Bill.Date) &
' Last Order Date: ' & max(Order.Date)". Bill.Date being the date field that shares a table with.
If you need any more information I will be glad to provide it.
EDIT I checked the variable overview and the definition for vSetBillMTD is
{$< Cancelled = {''},
[Inv PeriodID] = {$(=Max([Inv PeriodID]))},
Bill.Date = {"<=$(=Max(Bill.Date))"},
[Inv Year] = ,
[Inv Quarter] = ,
[Inv Period] = ,
[Inv Month] = >}
I do not know what the first line does but I still do not know why my invoice amounts are not being returned.
Since the variable is prefixed with a v ideally it should be referenced somewhere in the script so you are looking at the write place. However do check on these 2 aspects: Search for an include statement. Sometimes external files can be used to calculate variable values. As suggested by Alex, it could be that variable was defied in the UI and not the script , so going to Settings >> Variable Overview (shortcut: CTRL+ALT+V) will provide you with the list of variables that may have used.
You can also check in the Document properties (Settings >> Document properties). Shortcut: CTRL+ALT+D to see if you find anything in the Triggers tab. (Field event or Variable event trigger)
And your third option would be to look for an external data file (for example an Excel file, or a QVD in a configuration folder) that contains variable names and their definitions and that is read by the Dashboard each time it is reloaded.
Your predecessor may have implemented this technique to make the dashboard externally configurable (e.g. change the Dashboard behavior without changing the QVW document).
BTW the variable is probably meant to contain a set specification. It won't break the expression if it doesn't exist or contains nothing at all.
