topic Re: Past Due & Pending Action Buttons in QlikView

Past Due & Pending Action Buttons

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to create two action buttons. One that will show me "Past Due" and one that will show me "Pending". The formula I am using for "Past Due" is =If([Due Date]<Today(),[Due Date])...... The formula i am using for "Pending" is =If([Due Date]>=Today()and [Due Date]<= today()+7,[Due Date]). Both these Formulas work and show me what i want to see within a straight table. However, i am now trying to create Action Buttons that when you click on the "past due" button or "pending" button it will show you only those values.

Re: Past Due & Pending Action Buttons

Anil_Babu_Samineni — Thu, 08 Jun 2017 15:17:32 GMT

I would always recommend you to go these approaches for this

1) May be Adhoc reports

2) Could be possible with Hide and show option for 2 straight tables

Re: Past Due & Pending Action Buttons

neelamsaroha157 — Thu, 08 Jun 2017 15:26:02 GMT

Hi Matt,

You can create a variable for Hide/Show and in your table use that for showing one of the expression at one time.

Use the button to change value of the variable.

Re: Past Due & Pending Action Buttons

johnw — Thu, 08 Jun 2017 22:46:58 GMT

Seems to me you could do this with a new field and a list box instead of buttons.

if([Due Date]<today(),'Past Due',if([Due Date]<=today()+7,'Pending','Other') as Status,