topic Re: Get a value based on a selection in QlikView

Get a value based on a selection

bashar_f — Sun, 20 Jul 2014 07:29:13 GMT

I have a text object that displays a value from a variable, but I only want this value to show if a selection is made in list box, otherwise I want it to show 0.

Basically, I have a list box called semester with 2 values, 1301, 1401. the text object is called "Selected Semester" and it should show the result of the following expression only when a value is selected and for that specific value.

Count(EMPLID)

What should I write in the variable definition?

Re: Get a value based on a selection

ali_hijazi — Sun, 20 Jul 2014 07:30:29 GMT

Use the function GetSelectedCount(fieldName)

Re: Get a value based on a selection

bashar_f — Sun, 20 Jul 2014 07:34:40 GMT

But that only gives me the number of selected fields. What I want to do is get the count of EMPLID where the semester is equal to the selected one from the list box.

Re: Get a value based on a selection

ali_hijazi — Sun, 20 Jul 2014 07:38:26 GMT

then simply Count(EMPLID)

or in the definition of your variable write the following

=Count({<your_field={desired_value}>}EMPLID)>0

if this is not the case please elaborate more

Re: Get a value based on a selection

bashar_f — Sun, 20 Jul 2014 07:43:12 GMT

The code you wrote looks like what I want, but if only i can replace the "desired_value" with the selected value of the listbox, like if I selected 1401 from the listbox, I want 1401 to fill in the place of the desired value. The main thing here is that I want it to show 0 when nothing is selected and only act when something is selected.

Re: Get a value based on a selection

ali_hijazi — Sun, 20 Jul 2014 07:55:58 GMT

then replace desired_value with Concat(distinct field_name,',')

Re: Get a value based on a selection

ali_hijazi — Sun, 20 Jul 2014 07:57:30 GMT

use the following to check if a desired value is selected:

if(index(concat(distinct your_field,','),'your_desired_value')>0 ,1,0)

Re: Get a value based on a selection

MK_QSL — Sun, 20 Jul 2014 07:58:05 GMT

='Selected Semester : '&IF(GetSelectedCount(semester)>0,Count(EMPID),0)