Showing posts with label Community. Show all posts
Showing posts with label Community. Show all posts
Monday, May 11, 2015
QV Macro - External VBS File - PDF Printing - Excel Configuration
This summary is not available. Please
click here to view the post.
Labels:
Community,
QlikView,
QlikView Macro
Wednesday, April 8, 2015
Storing QlikView Table to CSV - ANSI encoding instead of UTF8 encoding
Thanks to the Community Posts : Created by Clever Anjos
https://community.qlik.com/docs/DOC-3712
Community Extract:
As we know QlikView stores text files only in UTF8 encoding.
For example
STORE MyTable to Export.csv(txt);
will save Export.csv as a UTF8 file.
If you need a file in ANSI encoding, QlikView does not provide an option to save it.
So I did this tiny program to convert the output of QlikView into ANSI
Example of use of it inside a QlikView Script:
STORE MyTable to Export.tmp(txt);
EXECUTE utf8_to_ansi.exe Export.tmp Export.csv;
------------------------------------------------------------------------------------------------------------------------------------------------------------
It really a Good Posts !!!
Labels:
ANSI encoding,
Community,
CSV,
QlikView,
STORE,
UTF8 encoding
Wednesday, November 19, 2014
QlikView ODBC Lotus Notes
Thanks to QV - Community Post for details : http://community.qlik.com/thread/12541
Very useful for LOTUS Note Connection
To use Notes data through ODBC, you must have:
- Notes SQL, the Lotus Notes ODBC driver
- An ODBC Driver Manager version 3.5 or later
- One of the following:
- Microsoft Windows 2000, or XP
- Microsoft Windows 2003 Server Standard Edition or Enterprise Edition
- Microsoft Windows Vista
- Microsoft Windows 2008
- Microsoft Windows 7
- One of the following:
- Lotus Notes Client release 6.0 or later
- Lotus Domino release 6.0 or later
- Lotus Notes Designer release 6.0 or later
- Lotus Domino Off-Line Services release 1.01 or later
OK, and then few steps: (this works in windows 7 x64)
1) Install NotesSQL - driver to C:\NotesSQL
2) add your Lotus Notes directory to the %PATH% Variable
3) Reboot
4) run c:\windows\syswow64\odbccad.exe
5) You should now find the NotesSql ODBC driver to create the ODBC connection normally
Sunday, November 16, 2014
QlikView - How to delete category from Access Point !
Customer Requirement:
QV Server Admin / Customer usually creates Document Categorization for Access
Point Application grouping.
This is done using under
- "http://localhost:4780/QMC/UserDocuments.htm#" - > "User Documents" - > "Document Information"
Issues:
- Also during UAT phase Multiple Categorization were created.
- But as we move to live environment and everyone would like to delete category from the Access Point.
- At this moment - there is no Wizard or QMC settings to do the same.
Solution:
We need to manually delete the categorization under
- C:\ProgramData\QlikTech\ManagementService\QVPR\Category.xml
- Delete the line that corresponds to the category you are looking for.
Thanks QV Support & Community Posts for helping on this issue.
Thursday, December 26, 2013
QlikView - Replacing NULL with Dummy Values
Below QlikView Edit Script will help to Replace NULL values with Dumy Values ::
MissingMap:
MAPPING LOAD
null(), 'Others!' AutoGenerate 1;
MAP [Business Line] USING MissingMap;
MAP Product_Family_Desc USING MissingMap;
MAP Cell USING MissingMap;
MAP Group USING MissingMap;
MAP Line USING MissingMap;
Material_Order_Master2:
NoConcatenate // This is important! We want a new table!
LOAD * RESIDENT Material_Order_Master;
DROP TABLE Material_Order_Master; // Drop the original table
MissingMap:
MAPPING LOAD
null(), 'Others!' AutoGenerate 1;
MAP [Business Line] USING MissingMap;
MAP Product_Family_Desc USING MissingMap;
MAP Cell USING MissingMap;
MAP Group USING MissingMap;
MAP Line USING MissingMap;
Material_Order_Master2:
NoConcatenate // This is important! We want a new table!
LOAD * RESIDENT Material_Order_Master;
DROP TABLE Material_Order_Master; // Drop the original table
Tuesday, December 10, 2013
QV - Firewall - Exception & Port Details
Below Cmd line codes helps to create FireWall exception for the QlikView Server.
netsh advfirewall firewall add rule name="QV Accespoint HTTP" dir=in profile=any action=allow protocol=TCP localport=80
netsh advfirewall firewall add rule name="QV Accespoint HTTPS" dir=in profile=any action=allow protocol=TCP localport=443
netsh advfirewall firewall add rule name="QV Access for Comand Center" dir=in profile=any action=allow protocol=TCP localport=4710
netsh advfirewall firewall add rule name="QV Access for Directory Service Connector" dir=in profile=any action=allow protocol=TCP localport=4730
netsh advfirewall firewall add rule name="QV Access for Distribution Service" dir=in profile=any action=allow protocol=TCP localport=4720
netsh advfirewall firewall add rule name="QV Access for QMC / QEMC" dir=in profile=any action=allow protocol=TCP localport=4780
netsh advfirewall firewall add rule name="QV Access for QV client / QlikOCX" dir=in profile=any action=allow protocol=TCP localport=4747
netsh advfirewall firewall add rule name="QV Access for WebServer" dir=in profile=any action=allow protocol=TCP localport=4750
netsh advfirewall firewall add rule name="QV Access Server Tunnel" dir=in profile=any action=allow protocol=TCP localport=4774
netsh advfirewall firewall add rule name="QV LDAP port" dir=in profile=any action=allow protocol=TCP localport=389
netsh advfirewall firewall add rule name="QV LDAP port over SSL" dir=in profile=any action=allow protocol=TCP localport=636
netsh advfirewall firewall add rule name="QV Accespoint HTTP" dir=in profile=any action=allow protocol=TCP localport=80
netsh advfirewall firewall add rule name="QV Accespoint HTTPS" dir=in profile=any action=allow protocol=TCP localport=443
netsh advfirewall firewall add rule name="QV Access for Comand Center" dir=in profile=any action=allow protocol=TCP localport=4710
netsh advfirewall firewall add rule name="QV Access for Directory Service Connector" dir=in profile=any action=allow protocol=TCP localport=4730
netsh advfirewall firewall add rule name="QV Access for Distribution Service" dir=in profile=any action=allow protocol=TCP localport=4720
netsh advfirewall firewall add rule name="QV Access for QMC / QEMC" dir=in profile=any action=allow protocol=TCP localport=4780
netsh advfirewall firewall add rule name="QV Access for QV client / QlikOCX" dir=in profile=any action=allow protocol=TCP localport=4747
netsh advfirewall firewall add rule name="QV Access for WebServer" dir=in profile=any action=allow protocol=TCP localport=4750
netsh advfirewall firewall add rule name="QV Access Server Tunnel" dir=in profile=any action=allow protocol=TCP localport=4774
netsh advfirewall firewall add rule name="QV LDAP port" dir=in profile=any action=allow protocol=TCP localport=389
netsh advfirewall firewall add rule name="QV LDAP port over SSL" dir=in profile=any action=allow protocol=TCP localport=636
Labels:
Community,
FireWall,
QlikView,
QlikView Server
Wednesday, October 2, 2013
It is possible to recover the Document CAL License?
Scenario:
User deleted the QlikView Document, for which the licenses were allocated. and also "Actually we forgot the Document Name"
Solution:
1)Stop the QlikView Server service.
2)Add PgoAsXmlAlso=1 under [Settings 7] in the Settings.ini file located in %ProgramData%\QlikTech\QlikViewServer (default location)
3)Restart the QlikView Server service
4)Navigate to Root Directory and Open the CalData.pgo.xml file to determine to which document the
CALs were assigned
5) Create a new blank QVW file named the same as document listed in CalData.pgo.xml & save it in
the Root directory
6) In Management Console, navigate to Documents > User Documents and locate QWV created in the
previous step
7) Click Document CALs tab and set Number of CALs allocated to this Document to zero and click
Apply
--
Thanks to QlikView Community posts
Labels:
Community
Thursday, August 22, 2013
Load variable from text file
QV - Community Posts:
http://community.qlikview.com/thread/89947
Method 1:
Load the Text file into QlikView & use Peek function to populate the Variable.
Variable_Table:
LOAD @1
FROM
Variable_Txt.txt
(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);
LET X=NUM(Peek('@1',0,'Variable_Table'));
Method 2:
Use Include Statement , to get the variable - if the text in file can be made as LET STATEMENT.
write "LET vPQLow = 54;"
And then INCLUDE this into the QV Script:
$(Include=C:\Path\vPQLow.txt);
http://community.qlikview.com/thread/89947
Method 1:
Load the Text file into QlikView & use Peek function to populate the Variable.
Variable_Table:
LOAD @1
FROM
Variable_Txt.txt
(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);
Method 2:
Use Include Statement , to get the variable - if the text in file can be made as LET STATEMENT.
write "LET vPQLow = 54;"
Labels:
Community
Forecast and Backcast - In Charts
From QV-Community Posts:
Expression tab:
| Trendlines | In selected QlikView charts expression plots can be complemented or replaced by statistical trend lines. Trend lines can only be displayed in scatter charts, line charts and in bar/combo charts with maximally one dimension and one expression shown as bars. For other types of charts, the settings in the Trendlines group are unavailable and have no effect. In scatter charts the data points are treated as if y=f(x). For bar, line and combo charts it is allowed to deselect all options under Display Options and still add trend lines, which will then be plotted without the underlying data points. Trend lines in bar, line and combo charts may be extrapolated by specifying a forecast and/or backcast interval (Axes page). The extrapolated lines will be dotted. Trend lines in charts with a discrete x-axis will be shown as lines with symbols. On a continuous axis only the line will be shown. The average is plotted as a straight line. Linear A linear regression line is plotted. Polynomial of 2nd degree A polynomial trend line of the second degree is plotted. Polynomial of 3rd degree A polynomial trend line of the third degree is plotted. Polynomial of 4th degree A polynomial trend line of the fourth degree is plotted. Exponential An exponential trend line is plotted. Show Equation If this check box is marked for a specific expression, the expression’s trend lines will be complemented by the trendline equation expressed as text in the chart. Show R2 If this check box is marked for a specific expression, the expression’s trend lines will be complemented by the coefficient of determination expressed as text in the chart. |
Axis tab:
| Backcast |
This function operates on trend lines. Enter into the text edit box how far back you would like to estimate the trend line. See Chart Properties: Expressions. The backcast portion of trend lines is displayed as dotted.
|
| Forecast |
Enter into the text edit box how far you wish to predict the trend line. See Chart Properties: Expressions. The forecast portion of trend lines is displayed as dotted.
|
So try creating a simple line chart (best with numerical axis), add any trendline (start maybe with a simple one, linerar, and play around with the options in axis tab).
Labels:
Community
Subscribe to:
Posts (Atom)