topic Re: listbox selection to load certain data in QlikView

listbox selection to load certain data

Thu, 26 Apr 2012 15:43:19 GMT

Hi all,

I am currently loading various qvds based on their date. the user can type into an input box the values which they wish to load. I want to change this to just selecting from a listbox instead of having to manually type the dates in?

I tried putting the variable as concat(Date, ',') but the function cannot be used in the script.

Has anyone ideas?

Just to clarify - I want to enable the user to select in a list box which dates they want to reload the data for?

thanks

listbox selection to load certain data

Thu, 26 Apr 2012 16:22:17 GMT

I did something similar hope it helps;

My application takes start and end date and puts them into a for loop and to create a inline calendar which is stored in calendar.qvd.

Then you can create your calendar table and put your date field into listbox so users can select what theyn wish...

Brief example is below

Let A=1;

let nextperiod= V_Calendar_Start;

int_nextperiod =Interval(nextperiod);

int_V_Calendar_Start=Interval(V_Calendar_Start);

int_V_Calendar_End=Interval(addmonths(V_Calendar_End,1));

For int_nextperiod =int_V_Calendar_Start to int_V_Calendar_End

Calendar:

LOAD * INLINE [ID, EFFECTIVE_START_DATE, YEAR,MONTH,Composite

$(A),$(Cal_date) 00:00:00,$(Cal_year),$(Cal_month),$(Composite)];

A=A+1;

nextperiod= addmonths (nextperiod,1);

int_nextperiod =Interval(nextperiod);

NEXT

store Calendar into QVD\Calendar.qvd (qvd);

Good luck

Max

listbox selection to load certain data

Thu, 26 Apr 2012 16:34:24 GMT

Thanks,

I have a loop created and a list of dates, eg 201202, 201203, 201204 etc.

My qvds are names 201202.qvd, 201203.qvd etc.

My issue is how do i translate my selections in this listbox into the dates on which I should perform my loop.

eg. I select 2 dates in my list box 201202 and 201203, my loop should then only reload the 201202 and 201203 qvds?

listbox selection to load certain data

Fri, 27 Apr 2012 09:22:28 GMT

Firstly I would find how many values are selected in your list box by using GetSelectedCount(Your_Field Name)

Then put this number in to a foor loop

For .....

get the selections on your list box by using GetFieldSelections(Your_field_name) into a variable ( Var_qvd) then

Load *

from

.... myqvd_$(Var_qvd);

Hope it helps...

Max

Re: listbox selection to load certain data

Fri, 27 Apr 2012 10:06:53 GMT

Hi colgbre01,

Tyr the attached sample qvw file.

I hope it might be helpful to you.

Regards
Venkat

listbox selection to load certain data

Fri, 27 Apr 2012 10:29:55 GMT

Hi,

The issue for this is that when the variable is created the script does not recognise the getfieldselections function? this may work on a text box on the front end but when coming to a load it simply gives tries to load from:

abc.getfieldselections(fieldname).qvd which obviously does not exist!

Re: listbox selection to load certain data

Fri, 27 Apr 2012 10:32:07 GMT

could you resend as a zipped file and not 7zip please satish?

Regards.

Re: listbox selection to load certain data

Fri, 27 Apr 2012 10:41:20 GMT

Hi,

Please check the zipped file.

Regards
Venkat

Re: listbox selection to load certain data

Fri, 27 Apr 2012 10:54:36 GMT

Great,

Looks exactly what i need...One more thing, could you post what the two variables are vSample and vABC?

Thanks

Re: listbox selection to load certain data

Fri, 27 Apr 2012 13:28:34 GMT

Hi,

vABC variable will holds the values selected in the field values of "A" after clicking on the button .

vSample variable will holds the values of vABC values.

i.e; if vABC holds like 201202,201203 then vSample in first for loop holds 201202 and in second for loop holds 201203.

I hope you understand now.

Regards,
Venkat

Re: listbox selection to load certain data

Fri, 27 Apr 2012 13:38:22 GMT

Venkat,

Thank you. i do understand where they come from but my issue is when i try and create them they are taken literally? eg. if i create my variable vABC as:

if(getselectedcount(ABC)>0, concat(getfieldselections(ABC), ','), getfieldselections(ABC))

my script will not run as it will say cannot find file

abc.if(getselectedcount(ABC)>0, concat(getfieldselections(ABC), ','), getfieldselections(ABC)).qvd?

This is where i am failing in my load process.

I have a listbox of loaddates which are selectable but my expression is not calculated - it is just taken as a string?

Re: listbox selection to load certain data

Fri, 27 Apr 2012 14:12:17 GMT

hi,

i think you might providing the expression in the variable itself.

is it right ?

Re: listbox selection to load certain data

jagannalla — Fri, 27 Apr 2012 14:13:26 GMT

Hello,

I worked out on your problem. Please check the attached file. It gives you perfect solution.

Re: listbox selection to load certain data

jagannalla — Fri, 27 Apr 2012 14:20:01 GMT

Please go through Settings-> Doc properties -> Field Event Triggers -> For a particular field i.e <Has action >Add Action(On select)

Once you make your selections in listbox reload the application.

Re: listbox selection to load certain data

Fri, 27 Apr 2012 14:20:47 GMT

Hi,

Don't write your expression in variable "vABC" just leave it empty.

Consider your LoadedDate field is "CreatedDate"

Go to Document properties --> Triggers --> FieldEventTriggers

And selecte the field "CreatedDate" and Click On Select Add Action --> External --> Set Variable --> Variable = vABC and Value = if(getselectedcount(ABC)>0, concat(getfieldselections(ABC), ','), getfieldselections(ABC)).

Hope now you will get the solution.

Regards
Venkat

Re: listbox selection to load certain data

Fri, 27 Apr 2012 14:23:47 GMT

Yes,

I think that is my issue. I created my variable by putting my expression in the variable overview area? Did you not do the same?

Re: listbox selection to load certain data

Fri, 27 Apr 2012 14:35:26 GMT

Yes , not to place the expression in the variable.

And please refer my previous post that gives a clear idea on how and where to set the expression for variable "vABC".

Regards
Venkat

listbox selection to load certain data

Fri, 27 Apr 2012 15:00:39 GMT

Thank you both for your help. I'm slightly unsure of vSample but will figure it out!

Re: listbox selection to load certain data

Fri, 27 Apr 2012 15:19:41 GMT

vSample is some thing like just holds the individual values of "vABC"

Ex:

For Each i in 0,1,2 //First loop it will run with 0 and fetches the qvd "0.qvd" , Second loop it will run with 1 and fetches the qvd data of "1.qvd", and so on..

Load *
From C:\$(i).qvd;

Now you might have an idea on the vSample.

Regards
Venkat