topic Re: Date selection based on a filed in QlikView

Date selection based on a filed

jeevays7 — Mon, 03 Jul 2017 10:15:26 GMT

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.

prma7799 — Mon, 03 Jul 2017 10:22:38 GMT

You want like this?

jeevays7 — Mon, 03 Jul 2017 10:34:58 GMT

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

prma7799 — Mon, 03 Jul 2017 11:01:31 GMT

Ok .

Could you please share some sample data?

jaumecf23 — Mon, 03 Jul 2017 11:10:28 GMT

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')))