Triggers with Text object for past days

[rkpatelqlikview]

Hi All,

I have created a variables in the backed.

LET vTodays=Peek('Datums', -1, 'Master');

LET vpast7days = Date(vTodays-7);

Let vpast15days = Date(vTodays-15);

LET vpast30days = Date(vTodays-30);

LET vpast90days = Date(vTodays-90);

How to call these variables in the text object with the colors when i click on the 7 days i need to see last 7 days data etc..

How can i achieve this one. Please any one can help on this?

thanks in advance.

[zhadrakas]

you can create a Trigger on click:

Trigger: Select Field

FIELD: your DATE FIELD

Expression: ='>=' $(vpast7Days)

[rkpatelqlikview]

Thanks for your response Tim,

Its correct one ='>=$(vpast7days)'. I did same thing but not working.

Please let me know what is the problem?

[zhadrakas]

This Should work.

='>=' & $(vpast7days)

[rkpatelqlikview]

Yes Tim. Previously its got worked but when added some data and refreshed then its stopped to work.

Is there any settings in Document properties?

what are the chances?

[rkpatelqlikview]

I have created and call this varaible in the front end text object

Here Datums is i renamed Date field as Datums;

LET vTodays=Peek('Datums', -1, 'Master');

=$(vTodays); -> In text object

Not showing any thing

[zhadrakas]

are you using IE-Plugin or AJAX Client?

Could you send a screenshot with your current selection and a TextBox with $(vpast7days) to check if everything is fine?

[zhadrakas]

there is your Problem. try to rollback your changes.

[rkpatelqlikview]

IE Plugin

I will send u screen shot

[rkpatelqlikview]

Thanks for your quick response Tim.

Please find the attached QVW