Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Community Browser