Filter out Options based on previous question Response

User Support Form Building
,
1

Hi Core Team,

My concern has not been resloved, for better understanding I am re-attaching my question set query ServicesFilter in Q3.xlsx (11.5 KB) for your reference. Please support me.

Regards,
Ramesh Pradhan

2

Hello @rameshpradhan

May be this post can help you out,

2 Likes
3

@Dnes, :bowing_man: :pray: :heart:

4

Hi Kal_Lam,

Not resolved it yet… could you please go through the questionniare I had shared…

Regards,
Ramesh

5

@rameshpradhan, please just share the part that is not working. Kindly please do not share the entire XLSForm. The community should be able to help you out.

6

Hi Team,

I am facing still problem filtering out the choices in Q3. I need to display only those options which is selected 1:4 in Q2a… to Q2e for respective options.

for Example if
Q2a. Telecom… response is 1
Q2b. Health …response is 3
Q2c. Sanitation …response is 2
Q2d. Food…response is 5
Q2e. Insurance… response is 2

then in Q3. only options those 1:4 selected options to be displayed as below…
Telecom
Health
Sanitation
Insurance

Here I have attached xlsForm file for better understanding.

Regards,
Ramesh Pradhan
xlsForm.xlsx (14.9 KB)

7

Hello @rameshpradhan

From Q2a- Q2e, if the respondent selected option (1 to 5) only then the responses that are selected in Q1 is displayed others wise it wont display in Q3. This is what I understood.

I had revised the excel form . please have look at it.
xlsForm_revised.xlsx (14.2 KB)

Hope this works for you.

Regards,
Dinesh Dongol

8

Hi Dnes,

It does not work, have tried uploading the xlsform that you have sent back.

Regards,
Ramesh

9

Hello @rameshpradhan

I had made slight changes in the calculation, in the pervious version its was wrong calculation sorry for that.

I had check at my end and its working fine .

Please get attached to the excel file.
xlsForm_revised.xlsx (14.2 KB)

Regards,
Dinesh Dongol

10

Thank you Very much for your support.

Thank you
Regards,
Ramesh Pradhan

11

Hi Dnes,

My requirement have been resolved. I had tried short calculation metods instead using long expressions, but does not work. Can you please review it and suggest me why it is not executing while loading form.

Thanks & Regards,
Ramesh Pradhan
xlsForm_revised-002.xlsx (16.0 KB)

12

hello @rameshpradhan

Glad it worked for you.

After reviewing your file, I had just removed the “;” that had been used in calculation from cq2a to cq2e.

Using of short calculation is working on my end . Hope this works for you as well. For reference, I had attached the excel file.

xlsForm_revised-003.xlsx (14.0 KB)

Regards,
Dinesh Dongol

1 Like
13

Thank you Dnes for your prompt response.

Motivated me to do further complex filter outs and etc…

Thank You and Regards,
Ramesh Pradhan

1 Like