topic Re: No data shown when opening sheet containing drop down list in App Development

No data shown when opening sheet containing drop down list

MartinGeb — Mon, 15 May 2023 13:17:29 GMT

Dear Community,

When opening a sheet that conatains basically 2 Drop Down lists (one for date and one for a company(=variable input field)) and some tables/charts, all the tables and charts are empty...see screenshot, although the given date and company have valid data.

The companies drop down list is done via a variable input field and basically works fine

ONLY if you go to the companies drop down list and choose ANOTHER company, the tables and charts fill with data.
If you THEN choose the company that was shown first hand, you can see the that companies data as well.

My question is: WHY DOESN'T THE SHEET SHOW THE DATA OF THIS COMPANY WHEN OPENING?

The real problem arises, when (due to authorisation restrictions) the person opening the sheet only sees ONE Company in the drop down list. THEN, there is NO CHANCE to see the data of this company, because the "click on another company and then go back to the original" (like described above) doesn't work any more.

Any Ideas appreciated.

Re: No data shown when opening sheet containing drop down list

Rohan — Tue, 16 May 2023 05:46:08 GMT

Hi,

It appears you are using Company Name in the set expressions for your visualizations right ?

& this restriction is set up using the Company Dropdown that you have created via a variable input, instead can you use a filter pane & remove the set expression for company name in your expressions ?

Kindly let me know if it works for you.

Thanks & Regards,

Rohan.

Re: No data shown when opening sheet containing drop down list

MartinGeb — Tue, 16 May 2023 12:59:56 GMT

The problem was my variable input field (creating my drop down list), where I basically used a dummy company name (which in no case could have been part of any drop down list result):

I replaced it with the following (where the result is definitely always part of the lists results) and now it works 🙂

=minstring([BD_COMPANY.COMPANY_NAME])

Thank you for your suggestion...working on it gave me the hint on what's wrong!