topic Make date using GetFieldSelections in QlikView

Make date using GetFieldSelections

Fri, 11 Jul 2014 16:06:04 GMT

Hi all

Can i use GetFieldSelections of Year, month and day in makedate function like

vselecteddate= makedate(GetFieldSelections(year),GetFieldSelections(month),GetFieldSelections(day))

if not how can i get the selected year,month and day as a date?

waiting for your answers.

Thanks in advance.

Bhavya

Re: Make date using GetFieldSelections

its_anandrjs — Fri, 11 Jul 2014 16:17:24 GMT

Possible click Ctrl + Alt + V and in the variables Overview

Make a variable like

vselecteddate =makedate(GetFieldSelections(Year),GetFieldSelections(NumMonth),GetFieldSelections(Day) )

Note:- Month field will be Number month values.

Re: Make date using GetFieldSelections

Fri, 11 Jul 2014 16:36:20 GMT

Thank you Anand Chouhan

can i use variables instead of GetFieldSelections in makedate

Re: Make date using GetFieldSelections

Fri, 11 Jul 2014 16:42:21 GMT

you can use variables,not sure how your year,month,day list boxes setup, if user is able to select multiple values (ex:2010,2011) makedate wont work ...

Re: Make date using GetFieldSelections

maxgro — Fri, 11 Jul 2014 16:43:46 GMT

GetFieldSelections if you have one selected value

this (or some other aggr function) if you want also manage no selections or many selected values

=MakeDate(max(Year), MAX(NumMonth), max(Day))

Re: Make date using GetFieldSelections

Fri, 11 Jul 2014 16:47:17 GMT

Thanks everyone for your answers

Re: Make date using GetFieldSelections

its_anandrjs — Fri, 11 Jul 2014 17:00:24 GMT

You are welcome Yes you can use variables but check which type of data in the fields you have and where you use makedate functions.