topic Re: Setting Variable based on value in Multibox..... in QlikView

Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 21:04:15 GMT

I have a multibox which contains FISYR, FISPD and WEDAT. I want to set a variable (vDate) based on the WEDAT the user selects. Help.

Thanks

Re: Setting Variable based on value in Multibox.....

MayilVahanan — Tue, 30 Oct 2012 21:07:46 GMT

Try like this

create a variable, vDate

value: =GetFieldSelections(WEDAT)

hope it helps

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 21:10:30 GMT

Thanks.....That is just what I was looking for.....

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 21:19:58 GMT

One added question. I have another variable based on vDate which looks like this =addmonths(vDate,-12). Is there a way to format the outcome? Currently it's MM/DD/YYYY and I would like it to be YYYY-MM-DD

Re: Setting Variable based on value in Multibox.....

CELAMBARASAN — Tue, 30 Oct 2012 21:20:56 GMT

Use Date(addmonths(vDate,-12),'YYYY-MM-DD')

or set Default date format as 'YYYY-MM-DD'

SET DateFormat='YYYY-MM-DD'; which is at the start of the file

Re: Setting Variable based on value in Multibox.....

MayilVahanan — Tue, 30 Oct 2012 21:21:24 GMT

Try like this

Make sure,vDate is a single value, for multiple value is not work

=Date(AddMonths(vDate,-12),'YYYY-MM-DD')

Hope it helps

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 21:24:12 GMT

Thanks

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 21:24:35 GMT

Thanks

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 22:26:39 GMT

Since you are on such a great roll I have one other question. I need to set a variable based on the FISYR_T and FISPD_T from a multibox, then calculate a rolling 12 months based on the selection....any ideas thanks Thom

Re: Setting Variable based on value in Multibox.....

MayilVahanan — Tue, 30 Oct 2012 22:50:59 GMT

Is both are FISYR_T and FISPD_T date field?? you want to load data between this values?

vFisyr = GetFieldSelections(FISYR_T)

vFispd = GetFieldSelections(FISPD_T)

=Sum({<Date = {'>=$(=Date(vFisyr))<=$(=Date(vFispd))'}>}Sales)

is not:

vStart =GetFieldSelections(WEDAT)

vEnd =Date(AddMonths(vDate,-12),'YYYY-MM-DD') // AddMonths(vDate,-12) acccording to date format

=Sum({<Date = {'>=$(=Date(vStart))<=$(=Date(vEnd))'},FISYR_T = {'$(vFisyr)'},FISPD_T = {'$(vFispd)'}>}Sales)

edit:

Am in outside. Sorry for incovenience. Tomo will post further.

hope it helps

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 23:01:49 GMT

Yes….they are both date fields. I will give them a try and let you know. Thanks again.

Re: Setting Variable based on value in Multibox.....

tmumaw — Tue, 30 Oct 2012 23:23:25 GMT

Both give me 0

Re: Setting Variable based on value in Multibox.....

tmumaw — Wed, 31 Oct 2012 12:07:41 GMT

The FISYR_T and FISPD_T are not date fields. The user can select from a Multi-Box a FISYR_T and FISPD_T as the starting point, then I need to go back 12 months to give them a rolling 12.

Thanks

Re: Setting Variable based on value in Multibox.....

MayilVahanan — Wed, 31 Oct 2012 13:00:56 GMT

Can you provide a sample file ? thats helpful to understand your requirement and solve it? is possible?

Re: Setting Variable based on value in Multibox.....

tmumaw — Wed, 31 Oct 2012 15:22:25 GMT

Mayil Vahanan,

Thanks for all your help. I found it...I was missing a ')' in the set analysis statement. I guess this happens when you look at something for too many hours. Thanks again for all your help you saved me a lot of time.

Thom

Re: Setting Variable based on value in Multibox.....

Mon, 15 Sep 2014 16:42:58 GMT

Hi..I have a multibox which has all the fieldsname (ID, Employees, Income). I have a variable vField. I want to set the value for this variable based on the field selection from the multibox (ID, Employees, Income). How can I do that ?