topic Re: IF file is to heavy ----> display a message in App Development

IF file is to heavy ----> display a message

Uri — Sat, 16 Nov 2024 01:18:25 GMT

Hi!

I want to display a message "The file you are trying to export is to large. It can take a few minutes to export it - reduce number of days and try again". IF my file is more than 6 mb or has more than 200 000 ROWS ---> SHOW A MESSAGE. I'm using table as a chart.

Is there is any way to do this?

BR,

Artur

Re: IF file is to heavy ----> display a message

ArnadoSandoval — Fri, 16 Oct 2020 04:57:52 GMT

Hi @Uri

These are some ideas:

The expression below returns the number of selected records, you can check its run-time value against you limit and display a message on the sheet, by the table's footnote, text box, KPI; replace Dimension with the name of the main dimension in your table.

Count(total [Dimension])

You may add a message like the ones shown below:

Re: IF file is to heavy ----> display a message

Uri — Mon, 19 Oct 2020 10:19:30 GMT

Good point @ArnadoSandoval ! It helped to fix my issue.

I used GetSelectedCounts on a date field. IF dateField has more than 60 days selected - display a message "Too many records selected - reduce number of days". I used show condition as well i.e. if more than 60 days selected - display a message else hide it. So it looks good now 🙂 Thanks for your reply!

BR,

Artur