Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
victorvasilyev2020
Contributor
Contributor

QlikView. Working with Excel

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

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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/Scr...

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/Scr...

One last link that may be the most helpful:

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.