topic Re: How to segregate different multiple files in qliksense in App Development

How to segregate different multiple files in qliksense

vinayvishwanath — Tue, 28 Aug 2018 13:48:02 GMT

Hi All,

i have multiple files to load in the format 201801, 201802........201812. which consists of required data in different columns eg: Budget and Forecast from 201801 to 201812.

My problem is : how to load the data with from multiple files without changing the script (it should load the latest files as well load old files also). 2. how to create a flag or label that upon selection returns value of the corresponding month. eg: if selection is done as 201804 then it has to return the corresponding values.

cumulative figures should also be available to show

Thanks

Vinay

Re: How to segregate different multiple files in qliksense

undergrinder — Tue, 28 Aug 2018 14:06:59 GMT

Hi Vinay,

This is from here - Qlik Sense - Loop through Excel Files and Works... | Qlik Community

Try this:

sub ReadMultipleExcel (Root)

       For Each File in filelist (Root&'\*.xlsx')

            YourTable:

            Load * FROM [$(File)] (ooxml, embedded labels, table is YourSheet)

       Next File

End Sub

Call ReadMultipleExcel ('lib://YourFiles')

It will loop through every xlsx file and read it's content.

As far as I get your state, you have same structured files, but other timestamp in filename.

The $(File) variable contains the filename, you can extract the date from it.

G.

you can loop through the files.

If I understand correctly the every file has a new column with the actual data, and retain the previous data as well?

Maybe you need only the last file right?

Can you provide us an example?

I think the crosstable option may help you in this case https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/LoadData/work-with-cross-tables.htm

Re: How to segregate different multiple files in qliksense

vinayvishwanath — Tue, 28 Aug 2018 14:30:32 GMT

Hi Gabor,

I have attached the test files as requested

Re: How to segregate different multiple files in qliksense

undergrinder — Tue, 28 Aug 2018 14:38:53 GMT

thank you!

As I see every file contains every column, so the looping through files solve the problem

Re: How to segregate different multiple files in qliksense

vinayvishwanath — Tue, 28 Aug 2018 14:43:18 GMT

thanks for the help really appreciated.