topic Re: calender dates in QlikView

calender dates

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

I want when i open the dashboard by default dates should be selected as follows:-

For current year

1st day of current month and current year - one day before system date ie 1st april 2018 till 23rd april 2018

for previous year

1st day of current month and previous year - one day before system date ie 1st april 2017 till 23rd april 2017

How to implement same?

Re: calender dates

YoussefBelloum — Tue, 24 Apr 2018 08:06:21 GMT

hi,

do you want to see the dates desribed above here ?

what are the variables used and what are their expressions?

Re: calender dates

Anonymous — Tue, 24 Apr 2018 08:44:12 GMT

yes I want same dates to be shown in calender

but i want this should be done using triggers

variables used area as follows:-

vstart for previous year starting date

vend for previous ear ending date

I have used triggers

vstart

monthstart(vstart)

but i want april 23,2017 to be displayed in calender. How to obtain that?

Re: calender dates

YoussefBelloum — Tue, 24 Apr 2018 08:59:38 GMT

What is the expressions used inside your variables: vstart and vend ?

Re: calender dates

Anonymous — Tue, 24 Apr 2018 09:05:24 GMT

=num(count({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >}DISTINCT SAPCode),'#,##0.0')

Re: calender dates

Anil_Babu_Samineni — Tue, 24 Apr 2018 10:31:19 GMT

Can you help us to consider as Field in selector and see that trigger working or not instead of Calendar?

Re: calender dates

Anonymous — Tue, 24 Apr 2018 10:45:13 GMT

if in trigger I am using monthstart(vstart)-1 its not giving correct answer in text box

Re: calender dates

Anil_Babu_Samineni — Tue, 24 Apr 2018 11:10:02 GMT

What value you are getting in text box when you use =vstart? Or =$(vstart)

Re: calender dates

Anonymous — Tue, 24 Apr 2018 11:16:16 GMT

vstart variable is functioning fine. I want vend variable to display 23rd april 2016

Re: calender dates

Anil_Babu_Samineni — Tue, 24 Apr 2018 11:17:56 GMT

Will you able to share sample?

Re: calender dates

Anonymous — Wed, 25 Apr 2018 02:04:27 GMT

I only want to display the default dates as first day of current month till one day before the system date so in that case my date should be displayed as 1st april 2018 - 24th april 2018.(under heading select date range for current year )

Similarly, for previous year dates should be displayed as 1st april 2017 - 24th april 2017(under heading select date range for previos year )

so how to implement the same ?

Re: calender dates

sudhirpkuwar — Wed, 25 Apr 2018 05:46:42 GMT

Hi,

Check this

Re: calender dates

Anonymous — Wed, 25 Apr 2018 12:46:25 GMT

what?

Re: calender dates

Anonymous — Wed, 25 Apr 2018 13:00:07 GMT

can it be done using makedate function ?

Re: calender dates

Anonymous — Wed, 25 Apr 2018 13:03:49 GMT

stalwar1‌ please help

Re: calender dates

sunny_talwar — Wed, 25 Apr 2018 13:08:19 GMT

Would you be able to share a sample to show what you have got

Re: calender dates

sudhirpkuwar — Wed, 25 Apr 2018 13:15:48 GMT

Did you check the attachment

It has calendar object as per your requirement....

Re: calender dates

Anonymous — Wed, 25 Apr 2018 13:24:40 GMT

its not visible...please resend

Re: calender dates

Anonymous — Wed, 25 Apr 2018 15:59:00 GMT

i cant use expression in calender as i have declared variable for calender and its used in expressions in charts as follows:-

=num(count({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >}DISTINCT SAPCode),'#,##0.0')

following is the code for calender in script :-

for i=2015 to 2018

for j=1 to 12

step1:

LOAD

RecNo(),

MakeDate($(i),$(j),RecNo()) as Sold_Date

AutoGenerate(31);

NEXT j;

NEXT i;

step2:

LOAD Sold_Date,

year(Sold_Date) as Year,

month(Sold_Date) as Month,

Date(monthstart(Sold_Date), 'MM-YYYY') as MonthYear,

day(Sold_Date) as day,

week(Sold_Date)as Week,

QuarterName(Sold_Date) as Quater1,

Dual(Date(Sold_Date, 'DD MMM'), (Month(Sold_Date) * 100) + Day(Sold_Date)) as Day,

WeekDay(Sold_Date) as weekday,

if(Ceil(Month(Sold_Date)/3)=1,'Q1',IF(Ceil(Month(Sold_Date)/3)=2,'Q2',IF(Ceil(Month(Sold_Date)/3)=3,'Q3',IF(Ceil(Month(Sold_Date)/3)=4,'Q4')))) as Quarter,

date(Sold_Date) as OrderDate

Resident step1;

drop Table step1;

Re: calender dates

Anonymous — Wed, 25 Apr 2018 16:23:51 GMT

Here if i am using in triggers as today-1 its functioning well for current year ending date. I am getting result as 24th april 2018

but its not functioning well for previous year ending date ie if i am using today -2 its giving values as 23rd april 2018 whereas i want values 24th april 2017 so how to implement the same?