Drill Down Question | XM Community
Skip to main content

Drill Down Question

  • September 2, 2022
  • 3 replies
  • 350 views
P
Forum|alt.badge.img

Hello everyone,
I am asking a state, county and zip code address in one survey question. I select the drill down question type and when I tried to add the excel file (containing list of state, count and zip code) for answers, Qualtrics said Import failed. Drill Down CSV or TSV files can only have up to 10000 cells. Our system detects that you are trying to import 116415 cells into this Drill Down question. Please shorten the list, reduce the number of columns, or consider using a different question type. Is there any other way to do that?
With regards,
Pooja Chhetri.

Aanurag_QC
N
R

3 replies

lizb311
Level 3 ●●●
Forum|alt.badge.img+20
  • lizb311
  • Level 3 ●●●
  • September 2, 2022

You can try asking what region respondents live in first. I'd use a list like this:

  • Midwest (OH, MI, IN, WI, IL, MN, IA, MO, ND, SD, NE, KS)

  • South (DE, MD, VA, WV, KY, NC, SC, TN, GA, FL, AL, MS, AR, LA, TX, OK, DC)

  • West (MT, ID, WY, CO, NM, NV, AZ, UT, CA, OR, WA, AK, HI)

  • Northeast (ME, NH, VT, MA, RI, CT, NY, NJ, PA)

Then add 4 drill-down questions (for state, county, and zip code), with display logic based on their selected region. The CSVs you upload should only contain the states in that region. That should hopefully make the import(s) small enough to work.

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • September 2, 2022

https://community.qualtrics.com/XMcommunity/discussion/22160/hello-everyoneIt is kind of complicated, but you can build your own drill down using JS, select2 and a web based database.
Personally, I wouldn't do a drop down; it is difficult for you and the respondent. I would have people enter just their zip code. Qualtrics will automatically populate an embedded data field with the state (e.g., QState_Q1). You could use a web service to look up the county.

lizb311
B
B
Forum|alt.badge.img

Hi Tom,

I am new to Qualtrics. Could you please explain the web service aspect to me?

My requirement is-

I have a CSV file with 10K rows and 10 columns. Since this exceeds the drilldown limit, I am looking for an alternative. Ideally, I want 9 questions to be auto populated based on the user's answer to the first dropdown. The dropdown answer should act as a lookup value to fetch data from the csv file to populate the answers for the other 9 questions. Is there any way to achieve this?"

Terms & ConditionsAccessibility statement