Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Remove filters in an Excel Pivot Table before Importing

Hi to all!!!

On the next image a pivot table that I´m trying to upload to Qlik Sense using script.

I all ready manage to transform the columns into a field using crosstable () but I do not know how to "un filter" a field on the excel file that contains data as seen in the next image. In the image you will find in the excel file a second tab but please do not take it into consideration.

Important to mention that the pivot table can be change manually in excel but the purpose is to make it automatically.

Any ideas? 

Script:

CrossTable(Grupo,Ventas)

LOAD

*
FROM [lib://Dropbox TD (xxxxxx)/Pruebas/TD Prueba.xlsx]
(ooxml, embedded labels, header is 2 lines, table is TD)
where not Cliente like '*Total*';

 

Captura de Pantalla 2019-08-28 a la(s) 10.25.30 a. m..png

 

 

1 Reply
Highlighted
Partner
Partner

Re: Remove filters in an Excel Pivot Table before Importing

try changing to:

header is 3 lines