Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)