topic Re: Select data from a loaded excel file in App Development

Select data from a loaded excel file

stekol61 — Thu, 28 Feb 2019 09:53:53 GMT

I have loaded this data from an excel file in my Sense app.

How can i select the value to a textbox for the current week and a specific country?

y_grynechko — Mon, 04 Mar 2019 22:55:45 GMT

Hey,

you need to get current week in correct format so the YYYY-WW, just add this to the loading script:

LET v_currentWeek = Replace(weekname(today()),'/','-');

After that in the text box add measure:

MinString({<Week = {'$(v_currentWeek)'}>}S)

This is what I get:

stekol61 — Tue, 05 Mar 2019 09:40:31 GMT

Should I change the format in the loading of the excel ?

LOAD
F1 as new_week,
Sweden,
Finland,
Norway,
Estonia,
Lithuania
FROM [lib://1.3.21.

y_grynechko — Tue, 05 Mar 2019 10:45:10 GMT

I think you can leave it as it is.

Just add this one line in the load script:

LET v_currentWeek = Replace(weekname(today()),'/','-');

and later on use it to show the data.

MinString({<Week = {'$(v_currentWeek)'}>}S)

Text in green will select the week based on the week of today's date. Red 'S' is where you type the name on the country you want to show.