QlikView App Dev

[sakshamkaul]

Hi

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 )

[mdmukramali]

Hi,

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.

[sakshamkaul]

Sir cn you please provide the sample application?

[mdmukramali]

Hi,

Kindly find the attached sample application.

[sakshamkaul]

his i have implemented but its not getting highlighted when i am opening the application ?

[mdmukramali]

Hi,

In your application what is the data format ?

can you attach sample application ?

[sakshamkaul]

this is my master calender

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,

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;

[mdmukramali]

Hi,

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.

[sakshamkaul]

If i want to select month from starting ie jan till current month then how to handle the same?

[mdmukramali]

Hi,

find the attached sample application.

Create a Trigger and Add an Action :

Select Possible on Month Field.