Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the huge data loaded. I do not want to give Clear All button to clear all the selections.
Is it possible after the dashboard is loaded, the objects like listbox,chart is selected based on todays date
Also,Is it possible that at any given point there should be atleast one value in Current Selection Box.
You can set the clear state, so when you press Clear button, the state is reset to a selection you can specify.
Select your desired values and set the clear state via menu.
Your other question may be solved using OnOpen trigger (in document properties - triggers) with a Select in field action.
Hi,
Is it possible after the dashboard is loaded, the objects like listbox,chart is selected based on todays date
Yes using triggers you can do that. (refer to the below screen)
Also,Is it possible that at any given point there should be atleast one value in Current Selection Box.
Yes you can do that by selecting always one selected value in list box/multi box (refer to the screen short)
Refer to the attached sample
Steps,
1) assume u have below data (i've changed my native formate to qlik format //u can also change at default variable main scipt
d
Load Date(Date#(Date,'YYYY-MM-DD'),'D/MM/YYYY') as NewDate,* Inline [
Product,Date,Sales
A,2018-01-22,1500
A,2018-01-24,1760
A,2018-01-26,1350
A,2018-01-30,2050
B,2018-01-22,1500
B,2018-01-24,1760
B,2018-01-26,1350
B,2018-01-30,2050
];
2) go to setting document properties -->triggers --document event trigger -->
Max(NewDate)
or
=Max({1}Date)
In doc properties, set onopen trigger