topic Passing values to variables based on selections in QlikView

Passing values to variables based on selections

Wed, 20 Apr 2011 19:01:50 GMT

Hi All,

I was wondering if it was possible to pass values to variables based on selections .

For eg. If I select a Year= 2010, the variable vDate should store the value 01/01/2010.

If I select Year= 2010 and Month=7, the variable vDate should store 07/01/2010.

It would be extremely helpful if someone could provide a solution.

Thanks,

Neeraj

Passing values to variables based on selections

Wed, 20 Apr 2011 19:06:29 GMT

You can use a GETFIELDSELECTIONS(your_field) function!!!

For more details...look a help from QV!!!

Passing values to variables based on selections

Wed, 20 Apr 2011 19:09:20 GMT

go to variable overview and make a variable like:

makedate([Year],[Month],[Day])

Which assumes you also have a [Day] field but if not just put 1 instead of day

There could be some issues like if you have more than one year or month selected in which case it isn't going to return anything. I could never figure out how to make that case work but it has something to do with concat I think...

Passing values to variables based on selections

patricio — Wed, 20 Apr 2011 19:18:38 GMT

You can define vDate to be:

=Only(Year)

In this case you have the year in vDate once you select only one Year.

You can also use other options depending what you really need to have in your variable.

Example if you define your variable to be:

=Only(Makedate(Year,1,1) )

you will have the first day of earch year. Example: 2010-01-01 whe you select only 2010.

Passing values to variables based on selections

Wed, 20 Apr 2011 19:25:59 GMT

Hi Erico, Trent,

Thank you very much for helping me out.

I think get field selections function will help me to deal with multiple selections as well.

Thanks,

Neeraj

Passing values to variables based on selections

Wed, 20 Apr 2011 19:34:56 GMT

Hi Patricio,

Thank you very much. A combination of the above 3 solutions should serve my purpose well. Will get back if I face hiccups.

Thanks,

Neeraj