I am using "Open Qlikview Document'" in Dashboard-1 to navigate to Dashboard-2.
I can not use "Open URL" as I need to pass variable values and multi box filter parameters to second dashboard.
In Dashboard-2, I am using Table Box to display data. I have three sheets there in this dashboard where I am showing different levels of data. In backend I have only one table in Dashboard-2.
Now my problem is that In second and third sheet of Dashboard-2, I need to show SALES data only
But in first sheet of Dashbaord-2, I need to show SALES and PROMOTION data . There is a table column name Sales_Type which has these two values in Dashboard-2.
Since I am using "Open Qlikview Document" to navigate to Dashboard-2, Triggers will not work. Also I am using Table Box to display data, I can not write any expression in Table Box chart.
Since these both dashboard are in production, I am thinking not to change Table Box to Straight Table.
