topic Re: Deselect a field in QlikView

Deselect a field

Mon, 08 Feb 2016 14:47:06 GMT

Hi,

Is there any way to deselect a field based on a expressions?

Like:

-IF(FIELD1>0, DESELECT_FIELD2, NULL())

Thanks!

Re: Deselect a field

sathishkumar_go — Mon, 08 Feb 2016 16:36:47 GMT

Could you explain your requirement briefly or post ur application with sample data

-Sathish

Re: Deselect a field

Mon, 08 Feb 2016 16:43:34 GMT

Can't post my data, to much private information

But want I want is:

I've the field Year, Month and Day:

Imagine that I've all the fields selected, but when I unselect the field Month I want automatically unselec the field Day because I don't want the Day selected without the Month.

I don't want to use a hierarchy group because I want the fields separeted.

Re: Deselect a field

Mon, 08 Feb 2016 16:46:44 GMT

Hi ,

Just curious when a month field is cleared or unselected then all its associated dates will also be deselected .

If the requirement is different excuse me.

regards

kumar

Re: Deselect a field

sathishkumar_go — Mon, 08 Feb 2016 17:02:36 GMT

Create a one variable,

vMonthSelected =GetSelectedCount(Month)

after that goto Settings->Document Properties -> Triggers -. Variable Event Triggers

select OnChange

In Actions -. choose clear field Day

-Sathish

Re: Deselect a field

Mon, 08 Feb 2016 17:07:08 GMT

Just fantastic!!! Thanks!