QlikView. Working with Excel

victorvasilyev2020 — Sat, 16 Nov 2024 03:25:04 GMT

I have the following piece of code in Qlik to see:

"Remove (Row, RowCnd (Interval, Pos (Higher, 2), Pos (Bottom, 1), Select (1, 0)))"

Can someone explain to me more or less what you are doing please, could it be converted into SQL format?

Forgiveness is attached to the complete QlikView table:

Aux1:

LOAD @5

FROM

[$(vGBUSharedrive)Stratus_2\StratusExtractionReport_NEW_WEEK2.xlsx]

(ooxml, explicit labels, table is Worksheet, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0)))

));

LET vPeriodOfDate = if(MID(PEEK('@5',0,'Aux1'),10,2)=MID(PEEK('@5',0,'Aux1'),25,2),MID(PEEK('@5',0,'Aux1'),10,2),'Differents Months');

LET vYearOfDate = if(MID(PEEK('@5',0,'Aux1'),13,4)=MID(PEEK('@5',0,'Aux1'),28,4),MID(PEEK('@5',0,'Aux1'),15,2),'Differents Years');

When I refer to SQL format, I mean if I have a database, could I do something similar? In plan: a Select * from (x table). Where to apply the mentioned condition

Re: QlikView. Working with Excel

Brett_Bleess — Wed, 03 Jul 2019 19:44:28 GMT

Provided the ODBC/OLE DB driver you are using can interpret your SQL commands properly, you can pretty much write a full SQL Query in the QlikView Script Editor and run things...

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/SQL.htm

The Help is pretty sparse, but really things are just limited by what the SQL driver you are using will translate etc. Hope this is what you needed to move forward here.

Almost forgot, you may need the Help on the Connect strings:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/CONNECT.htm

One last link that may be the most helpful:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Create_Select_Statement.htm

Regards,
Brett

topic QlikView. Working with Excel in QlikView

QlikView. Working with Excel

Re: QlikView. Working with Excel