limit data in table by variable

[omyahamburg]

Dear all

I am struggling.

I have a table as follows:

To calculate the days overdue I use the expression today()-[Due Date].

Now I want use a variable, e.g. vDay=500 and I like to limit the data in the table

only to show me those rows, where today()-[Due Date] <= 500 is.

I appreciate your help.

Joerg

[Anonymous]

HI,

1. create a Input box , declare a global variable  and attcahe  that variable to input box.

2. In your Sum(AMOUNT) expression write this expression  if(today()- [Due Date ] <=500,SUM(AMOUNT))

      now when you enter a value in input box press enter key by which variable will be set by a value.

      to clear  variable value create a button named clear and setvariable to 0. 

Regards,

ANANT

[#3]

Hi

Go to dimension click on edit Document No dimension and replace with following expression :

=if (Today()-[Due Date]>=500 , [Document No])

Thanks

[vikasgupta]

Hi

Find the sample !!

[omyahamburg]

Dear Vikas, dear anantmax

I combined both your solutions.

I created a variable vDay and changed the Document No dimension with the following expression : 

=if (Today()-[Due Date]<=vDay , [Document No]) and selected suppress zeros.

In the input box I can now "play" with the different values.

Also I created the mentioned button to set the variable:

=max(today()-[Due Date])

This sets the table back to show all values.

Thank you both for your help.

Have a good weekend.

Joerg

[#6 · Accepted solution]

Hello Joerg,

You can also avoid using an addition button, by using

=if(Today()-[Due Date] <= if('$(vLimitData)' = '',Today()-[Due Date],$(vLimitData)),[Document No])

instead of your [Document No] dimension.

Please find attached qvw.

Thanks,

iota

[omyahamburg]

Dear Itsangad

A very nice solution. This should fit my needs best.

Have a good weekend.

Joerg

[#8]

Thanks Joerg !

Please mark the question as answered.

Have fun !

Thanks,

itsangad

[omyahamburg]

Dear Itsangad

Do you have also an idea how I can achieve this ?

Joerg

[#10]

Hello Joerg,

The same has been implemented in the attached qvw.

Please let me know, if you find it helpful or anything else is required.

Thanks,

itsangad