Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Past Due & Pending Action Buttons

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.

3 Replies
Highlighted

Re: Past Due & Pending Action Buttons

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist II
Specialist II

Re: Past Due & Pending Action Buttons

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.Capture.PNG

Highlighted
MVP
MVP

Re: Past Due & Pending Action Buttons

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,