topic Re: Disabling selections on conditions in QlikView

Disabling selections on conditions

kushalthakral — Tue, 22 Apr 2014 07:07:45 GMT

Hi All

i have a following requirement:

i have a Fiscal Year Selection and Current Year selection

if user selects one of them then other should be disabled and user should not be able to select

For Ex:

If user selects Current year then fiscal year selection should be disabled same vice versa

Thanks

Kushal Thakral

Re: Disabling selections on conditions

Tue, 22 Apr 2014 07:11:01 GMT

Can u post ur sample application??

Re: Disabling selections on conditions

Tue, 22 Apr 2014 07:13:01 GMT

Hi Kushal,

You can use conditional show for this.

I am assuming you have 2 list boxes each for Fiscal year and Current Year.

If so, then you can make them conditionally visible on:

Fiscal Year:

GetFieldSelection([Current Year]) =0

Currennt Year:

GetFieldSelection([Fiscal Year]) =0

This way, as soon as you will select anything in one list box, other will disappear.

Hope this helps!

EDIT: Alternatively, you can use Actions/Triggers as well.

Re: Disabling selections on conditions

anbu1984 — Tue, 22 Apr 2014 07:27:36 GMT

Check this Disable a listbox when ...

Re: Disabling selections on conditions

kushalthakral — Tue, 22 Apr 2014 07:29:57 GMT

Hi Shyam

I m tried it but when i apply the formula it disappear immediately without any selection

Please help.

Regards

Kushal

Re: Disabling selections on conditions

Tue, 22 Apr 2014 07:32:59 GMT

Can you try using "GetSelectedCount" instead of "GetFieldSelection"?

Re: Disabling selections on conditions

Tue, 22 Apr 2014 07:45:51 GMT

Use the below expression":

In Fiscal Year conditional:

if(getselectedcount(CurrentYear)>0,0,1);

In Current Year conditional:

if(getselectedcount(FiscalYear)>0,0,1);

Hope this will help you..!

Re: Disabling selections on conditions

Tue, 22 Apr 2014 07:46:07 GMT

Use the below expression":

In Fiscal Year conditional:

if(getselectedcount(CurrentYear)>0,0,1);

In Current Year conditional:

if(getselectedcount(FiscalYear)>0,0,1);

Hope this will help you..!

Re: Disabling selections on conditions

kushalthakral — Tue, 22 Apr 2014 08:27:07 GMT

Thanks Priya

It works

Regards

Kushal Thakral

Re: Disabling selections on conditions

anbu1984 — Tue, 22 Apr 2014 08:39:04 GMT

Using GetFieldSelections()

In Fiscal Year conditional:

if(IsNull(GetFieldSelections(CurrentYear)),1,0)

In Current Year conditional:

if(IsNull(GetFieldSelections(FiscalYear)),1,0)