Discussion Board for collaboration related to QlikView App Development.
I want when when I open my aapplication By default current year ie 2018
all the months upto current month ie- feb and date ie current date-1 should be automatically be selected in the list box (selection shown in green )
You can use Triggers to select the Max Year & MaxDate-1 by default when you open an application,
kindly find the the attached sample application.
Sir cn you please provide the sample application?
Kindly find the attached sample application.
his i have implemented but its not getting highlighted when i am opening the application ?
In your application what is the data format ?
can you attach sample application ?
this is my master calender
for i=2015 to 2018
for j=1 to 12
MakeDate($(i),$(j),RecNo()) as 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,
QuarterName(Sold_Date) as Quater1,
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
drop Table step1;
Kindly find the attache file,
in your application the Year filed name is year.
so make sure you are using same field name in the trigger.
If i want to select month from starting ie jan till current month then how to handle the same?
find the attached sample application.
Create a Trigger and Add an Action :
Select Possible on Month Field.