Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
kushalthakral
Creator III
Creator III

Disabling selections on conditions

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

1 Solution

Accepted Solutions
Not applicable

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..!

View solution in original post

9 Replies
Not applicable

Can u post ur sample application??

Not applicable

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.

anbu1984
Master III
Master III

kushalthakral
Creator III
Creator III
Author

Hi Shyam

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

Please help.

Regards

Kushal

Not applicable

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

Not applicable

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..!

Not applicable

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..!

kushalthakral
Creator III
Creator III
Author

Thanks Priya

It works

Regards

Kushal Thakral

anbu1984
Master III
Master III

Using GetFieldSelections()

In Fiscal Year conditional:

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

In Current Year conditional:

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