Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

srikantj
Contributor

triggers should stay after clear all button clicked

Hi

I created trigger on fileld (ex: country: india) on activate sheet but after clear all button those filters are getting cleared

i want to keep them even after clear button is pressed

QLIkSSSSSSS.. Suggest

7 Replies
krishna20
Valued Contributor II

Re: triggers should stay after clear all button clicked

Hi Srikanth Better you can use always selected value in listbox propertied

it will not impact any clear selection

Thanks

MVP
MVP

Re: triggers should stay after clear all button clicked

srikantj
Contributor

Re: triggers should stay after clear all button clicked

i want three selections not one

agrimroquette
Valued Contributor

Re: triggers should stay after clear all button clicked

LOAD Phase,

         

          IF(Phase='OPPORTUNITY', ' Opportunity',IF(Phase='PROJECT', 'Project',IF(Phase='FEASIBILITY', 'Feasibility'

           ))) as PhaseClassification

FROM [lib://PPM/FinalDataPoints.xlsx]

(ooxml, embedded labels, table is Sheet1);

agrimroquette
Valued Contributor

Re: triggers should stay after clear all button clicked

like this you can load that field and include only those values that you require to show

agrimroquette
Valued Contributor

Re: triggers should stay after clear all button clicked

or you can use

MAPPING:

MAPPING LOAD * inline [

Old, New

1,one

2, one

3, two

];

map [Global Weather Situation] using MAPPING;

you can use this after you load main table

srikantj
Contributor

Re: triggers should stay after clear all button clicked

i reqiure other values in other charts..i cant load like this