How to create actions for

[#1]

Hi Experts,

I have vendor table with Vendor,vendor status,Vendor status having values active and null values.i want dispaly any sheet object with yes,no.if we click on no i need to get only Active vendors,if clik on yes i need to get all values of vendor.

Thanks,

Siva

[#2]

Can you please share the QVW.

Thanks

siva

[varshavig12]

Do you want something like this:

*** When you click on 'Yes' only active vendors

*** When you Click on 'No' all vendors

Note: 'Yes' automatically gets selected.

if you want something like this

make use of two list box

list box 1:

=if(Status='active' or Status='not active' or Status='','no')

list box 2:

=if(Status='active','yes')

[varshavig12]

Can you please post your expression ?

I cannot open this qvw.

[#5]

How we can get yes and no keywords it's showing error.

thanks

[Anil_Babu_Samineni]

Try this,

[#7]

What i have try ?

No information available...

[sampada0810]

You can use conditional show/hide

[susovan]

Hi Varsha,

Try this expression,

=Only({<[Vendor Status]={'active'},Status={'No'}>}[Vendor Status])

[varshavig12 · Accepted solution]

Sample app with Yes and NO

[Anil_Babu_Samineni]

Did you check my Attachment?