Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Goofy File

I'm importing a rather akward .xlsx file.  The table structure looks

Company      Project     Invoice Number     Amount

Company x 

                    project b    

                                        ######                 $#####

                                        ######                 $#####

Company y

                    project c

                                        ######                  $#####

It carries on like this for a quite some time.

These are weekly reports (from outside vendor) modifing them directly is not really an option.  The bosses don't care about real time either they prefer "Snap Shot" data analysis.

0 Replies