topic Re: Button Help???? in QlikView

Button Help????

amit_saini — Thu, 15 May 2014 07:31:42 GMT

Hi Folks,

I'm having to variables as mentioned below:

vDateStart =timestamp($(vDtStart) + $(vTsStart)/24)

vDateEnd =timestamp($(vDtEnd) + $(vTsEnd)/24)

Requirement: Please help me how to create a button by using these two variables or without them to see yesterday 6:00 AM to Today's 6:00 AM data.

Note: I'm using vDateStart and vDateEnd variables in all my expressions inside Pivot table and by pressing this button data should change automatically .

Thanks,

Re: Button Help????

ashfaq_haseeb — Thu, 15 May 2014 07:48:25 GMT

Hi,

Below Application might help you.

Regards

ASHFAQ

Re: Button Help????

Thu, 15 May 2014 08:16:24 GMT

you have to set a trigger when you click the button to change the value to yesterday 6am to today 6am and then you can still use it in set analysis. meaning you dont have to change your expression.

regards,

Re: Button Help????

amit_saini — Thu, 15 May 2014 08:42:30 GMT

Hi Magdalena,

Could you please share any demo application if possible.

Thanks,
AS

Re: Button Help????

amit_saini — Thu, 15 May 2014 08:44:11 GMT

Ashfaq,

Thanks for the help, but in your case you are having date filed , in my case there is no such date field . I need solution by using these two variables.

Thanks,

Re: Button Help????

CELAMBARASAN — Thu, 15 May 2014 08:52:31 GMT

How could you identify without date field whether data is today's or yesterdays one?

Because formula would be based on that only

Re: Button Help????

amit_saini — Thu, 15 May 2014 09:10:58 GMT

Celambarasan,

I'm using variables over here, it can be done using assigning today's and yesterday's value to these variables.

vDateStart =timestamp($(vDtStart) + $(vTsStart)/24)

vDateEnd =timestamp($(vDtEnd) + $(vTsEnd)/24)

I have created a Calender by using vDtStart and vDtEnd by assigning them values from =Date('01.01.2012', 'DD.MM.YYYY') to =Today() , where a user can select any date .

Also I have created a Slider for selecting time ranges by using vTsStart and vTsEnd variables. Please see this image.

Here for example I have selected 5th May 2014 as from and to but I have selected time from 4:00 AM till 5:00 AM same dat , and you can see below in Production Overview table data got changed accordingly.

Available Time showing is exactly 01:00 hrs difference which is correct.

And in my all expressions I 'm using vDateStart and vDateEnd , so whenever a user selecting any date and time range as described above data will automatically change in table.

Further here I want a button , which can gives me Yesterday's and Today's 6 to 6 AM.

Please suggest or help me out here.

Thanks,

Re: Button Help????

CELAMBARASAN — Thu, 15 May 2014 09:22:11 GMT

Use this 2 set variable actions

vDateStart =timestamp(Today() - 1 + ((1/24) * 6))

vDateEnd =timestamp(Today() + ((1/24) * 18))

vDateStart =timestamp(Today() - 1 + Time(Time#('06:00 AM', 'hh:mm tt')))

vDateEnd =timestamp(Today() + Time(Time#('06:00 PM', 'hh:mm tt')))

vDateStart =timestamp(Today() - 0.75)

vDateEnd =timestamp(Today() + 0.75)

Re: Button Help????

Anonymous — Thu, 15 May 2014 09:27:37 GMT

Hi amit,

can you post your qvw or an example? I agree with Magdalena. You should use some triggers.

Best regards

Re: Button Help????

amit_saini — Thu, 15 May 2014 09:47:54 GMT

Hi ,

Mentioned below is my test application. Kindly have a look on it.

Thanks,
AS

Re: Button Help????

amit_saini — Thu, 15 May 2014 09:52:00 GMT

Also please use the values againstvSatartDate & vEndDate

vStartDate =timestamp($(vDtStart) + $(vTsStart)/24)

vEndDate =timestamp($(vDtEnd) + $(vTsEnd)/24)

Thanks,
AS

Re: Re: Button Help????

Anonymous — Thu, 15 May 2014 10:07:47 GMT

Hi amit,

I am not sure if i really understood what you want. But in this example i added the date and time is changed to Yesterday's and Today's 6 to 6 AM. It changes the values in your calendar and slider. And if i understood you then the table below should limit its values.

I just used the actions --> External --> Set variable.

Is that what you looking for?

Best regard

Theresa