topic Re: Variable Script Field based on Dashboard Selection in QlikView

Variable Script Field based on Dashboard Selection

Mon, 29 Sep 2014 16:17:12 GMT

I want to have two fields that will be populated with the minimum and maximum dates selected.

The minimum and maximum dates will be taken from a concatenated table so they need be pulled using an IF statement.

something like If ( Table = 'STOCK', Max (Date))

I would want this to be a separate field in my table so that the same date would run down my data and can be used to created a separate "SUMIF"

Re: Variable Script Field based on Dashboard Selection

Anonymous — Mon, 29 Sep 2014 20:29:40 GMT

If you want max and min dates of the user selection, then it wouldn't be calculated in the script. I would recommend using set analysis for that. Also, once you run the script your "concatenated tables" become 1 table inside the dashboard....that's the whole purpose of concatenating tables. Are you saying that the user is going to be selecting the name of a table? Will need a sample file or example of your data structure to understand the question what you're trying to accomplish.

Re: Variable Script Field based on Dashboard Selection

Wed, 01 Oct 2014 13:10:37 GMT

I've changed my approach as you said it wouldn't be calculated in the script. Many thanks for your help