topic Current Selections Box in QlikView

Current Selections Box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Current Selections Box

swuehl — Mon, 29 Jan 2018 18:57:20 GMT

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.

Re: Current Selections Box

devarasu07 — Mon, 29 Jan 2018 19:00:46 GMT

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)

=Max({1}Date)

Re: Current Selections Box

shiveshsingh — Tue, 30 Jan 2018 06:57:23 GMT

In doc properties, set onopen trigger