topic Re: Triggers with Text object for past days in QlikView

Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 10:29:59 GMT

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.

Re: Triggers with Text object for past days

zhadrakas — Mon, 18 Dec 2017 10:37:46 GMT

you can create a Trigger on click:

Trigger: Select Field

FIELD: your DATE FIELD

Expression: ='>=' $(vpast7Days)

Re: Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 10:52:35 GMT

Thanks for your response Tim,

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

Please let me know what is the problem?

Re: Triggers with Text object for past days

zhadrakas — Mon, 18 Dec 2017 11:35:44 GMT

This Should work.

='>=' & $(vpast7days)

Re: Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 12:31:07 GMT

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?

Re: Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 12:36:59 GMT

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

Re: Triggers with Text object for past days

zhadrakas — Mon, 18 Dec 2017 12:41:11 GMT

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?

Re: Triggers with Text object for past days

zhadrakas — Mon, 18 Dec 2017 12:45:28 GMT

there is your Problem. try to rollback your changes.

Re: Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 12:58:10 GMT

IE Plugin

I will send u screen shot

Re: Triggers with Text object for past days

rkpatelqlikview — Mon, 18 Dec 2017 13:08:00 GMT

Thanks for your quick response Tim.

Please find the attached QVW

Re: Triggers with Text object for past days

zhadrakas — Mon, 18 Dec 2017 13:14:48 GMT

check attachment