Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshamkaul
Creator II
Creator II

BY DEFAULT CURRENT SELECTION SHOULD BE SELECTED FROM LIST BOX

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 )

paint1.png

11 Replies
mdmukramali
Specialist III
Specialist III

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
Creator II
Creator II
Author

Sir cn you please provide the sample application?

mdmukramali
Specialist III
Specialist III

Hi,

Kindly find the attached sample application.

Capture.PNG

sakshamkaul
Creator II
Creator II
Author

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

mdmukramali
Specialist III
Specialist III

Hi,

In your application what is the data format ?

can you attach sample application ?

sakshamkaul
Creator II
Creator II
Author

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
Specialist III
Specialist III

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
Creator II
Creator II
Author

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

mdmukramali
Specialist III
Specialist III

Hi,

find the attached sample application.

Create a Trigger and Add an Action :

Select Possible on Month Field.