topic Re: Activating the button based on certain condition in QlikView

Activating the button based on certain condition

qlikviewforum — Mon, 21 Apr 2014 08:36:42 GMT

I have two buttons in a QVW as follows and I have a table called Issues.

1. Approve Issues
2. Approve Loan

I want to activate the "Approve Loan" button only if there are no rows in "Issues" tables. If there are any records avaiable in the "Issues" button then only when I click on the "Approve Issues" the "Approve Loan" button should be activated.

Can you please help for the same?

Re: Activating the button based on certain condition

MK_QSL — Mon, 21 Apr 2014 08:47:34 GMT

can you please share your sample apps?

Re: Activating the button based on certain condition

its_anandrjs — Mon, 21 Apr 2014 08:49:29 GMT

Updated New

In Layout properties write

if(Count(Issues) > 0,1,0)

See the snap shot.

Re: Activating the button based on certain condition

jagan — Mon, 21 Apr 2014 09:08:00 GMT

Hi,

Use Enable Condition in Button Properties tab.

Regards,

Jagan.

Re: Activating the button based on certain condition

qlikviewforum — Mon, 21 Apr 2014 19:23:21 GMT

Hi Jagan,

This didn't work out.Please help me out.

If there is no rows then load approve button should be activated and if there are any rows then on click on approve issue the approve loan button should be activated.

Please let me know if you have any questions.

Re: Activating the button based on certain condition

jagan — Tue, 22 Apr 2014 02:10:18 GMT

Him

For Load Approve button

If(Count(DimensionName) = 0, 1, 0)

For Approve Issue button

If(Count(DimensionName) > 0, 1, 0)

Hope this helps you.

Regards,

Jagan.

Re: Activating the button based on certain condition

qlikviewforum — Tue, 22 Apr 2014 03:19:11 GMT

Hi Jagan,

Thanks for your response.

It not the count(Dimension) I should check. I want to check is there is any records in the "Issues table". If there are any records exists then "Load Approve" button should be enabled only when "Approve Issue" button is clicked. If there are no records exists in the "Issues table" then both "Load Approve" button and "Approve Issue" button can activated automatically.

Please let me know if you have any questions.

Re: Activating the button based on certain condition

jagan — Tue, 22 Apr 2014 03:46:16 GMT

Hi,

Can you attach some sample file?

Regards,

Jagan.

Re: Activating the button based on certain condition

Greg_Williams — Tue, 22 Apr 2014 05:13:45 GMT

How about trying something like:

(in the chart properties tab)

=if(GetCurrentSelections([name of field]) > 0,1,0)

...this should hide the appropriate object

Hope this helps.

Greg

Re: Re: Activating the button based on certain condition

qlikviewforum — Tue, 22 Apr 2014 17:03:59 GMT

Hi Jagan,

Please find sample attached

If there are any rows exists in the Customer table then only after clicking the "Approve Issues" button the "Approve Loan" button should be activated. If there are no rows exists in the Customer table then "Approve Loan" should be activated automatically.

Hope it is understandable now. Please let me know if you have anymore questions.

Re: Activating the button based on certain condition

qlikviewforum — Wed, 23 Apr 2014 06:58:50 GMT

Hi Jagan,

Did you get a chance to look into the sample qvw? If not please take a look when you are free.