Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Date selection based on a filed

Hi all,

I have a field the name of "Type" with two values "WTD","MTD".

and i have a "Date" column.

Now i need to select the dates between From Date and ToDate in date column when i am selecting a field value in Type column.

i am assigning from date and to date values in "vFromDate" and "vToDate" variables when you select a field value in "Type"Column.

I write variable event trigger in both variable to select the date. but it is not selecting the dates in Date column.

but the variable is showing the correct date values when i am selecting a value in the type column.

help me.

4 Replies
Highlighted
Master III
Master III

You want like this?

Highlighted
Partner
Partner

Hi P M,

I need the date selection when we selecting a field value.

Ex; in my Type column, i have two values.

if i select MTD, then the date column should select the dates between from month start date to month end date

Highlighted
Master III
Master III

Ok .

Could you please share some sample data?

Creator III
Creator III

Maybe something like this for MTD:

vFromDate : =Min({1<Month={$(vMaxMonth)},Year={$(vMaxYear)}Date)

vToDate : =Max({1<Month={$(vMaxMonth)},Year={$(vMaxYear)}Date)

vMaxMonth : =Month(Max({1}Date#(Date,'YYYYMMDD')))

vMaxYear : =Year(Max({1}Date#(Date,'YYYYMMDD')))