topic Re: Using Variable From and To in calendar object in QlikView

Using Variable From and To in calendar object

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

I have a query I want to write an expression in which I have variable named FROM in which i have passed a value as

FROM =date(Date#(lastDate)-$(compday),'DD/MM/YYYY')

and another variable as

TO =date(Date#(lastDate),'DD/MM/YYYY')

Following variable is used in a calender Object as shown below :-

so here From variable is taking value as 01/10/2017 andTo variable is taking value as 10/10/2017.

Now when I am writing an expression using the following variable FROM and TO it is not giving me desired result

Please help stalwar1‌

Re: Using Variable From and To in calendar object

lironbaram — Thu, 01 Nov 2018 09:03:02 GMT

what expression do you use in the table

can you give some more information

Re: Using Variable From and To in calendar object

sakshikaul — Thu, 01 Nov 2018 09:17:15 GMT

I am using following expression in pivot table object

=sum({StateA< lastDate = {">=$(From)<=$(To)"} >} [inv value])

Re: Using Variable From and To in calendar object

lironbaram — Thu, 01 Nov 2018 10:00:43 GMT

you need to make sure that your variables are in the same date format as the Date field

in your case try to format them to 'D/M/YYYY'

Re: Using Variable From and To in calendar object

sunny_talwar — Thu, 01 Nov 2018 10:41:53 GMT

Would you be able to share a sample qvw to check this out?

Re: Using Variable From and To in calendar object

sakshikaul — Fri, 02 Nov 2018 06:46:21 GMT

I am not able to attach qvw

Please help

Re: Using Variable From and To in calendar object

Anil_Babu_Samineni — Fri, 02 Nov 2018 06:53:09 GMT

May be

=sum({StateA< lastDate = {">=$(=From)<=$(=To)"} >} [inv value])

Re: Using Variable From and To in calendar object

sakshikaul — Fri, 02 Nov 2018 07:37:41 GMT

Hey

I think this calendar object is not a good idea to use here rather I should simply assign a value to a variable and Please help me how to call that variable in an expression ?

here in the above picture when the user will enter comparison no. of days as 8 then the date will be calculated as

10 oct 2018 -8=2/10/2018

so now 2/10 /2018 will become start dtae taken in text box and end_date will be always the last_date in this case

and last_date is actually a field name

Now how to use these variables in table expression?

start date text box contains following

=date(date(DaysOfComp),'D/M/YYYY')

end_date

=date(lastDate,'D/M/YYYY')