Qlik Community

Techspert Talks

Here you'll find the recordings of our Techspert Talks sessions (formally Support Techspert Thursdays).

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Troubleshooting Qlik Sense (Part2) - Application and data connectivity

In this session we will focus on:

  • Technology stack, Web browser, development tools and Qlik Desktop Wrapper
  • New QVD file format and compatibility
  • KML file in Map chart
  • Sorting Master items
  • Working with Data Load Editor



For best viewing, we recommend you set the highest video resolution.


Q&A

Q: what is the difference of RecNo() of qliksense from IterNo() of qlikview ?

A: RecNo() and IterNo() both return an integer. However, RecNo() returns the position of a row in the RAW data (source data table), and IterNo() returns which round is a row be evaluated in the loop (calculated data table).

So say the main difference is that they work in different phases of a calculation. An example will be:

Assume you have a CSV file called Tab1.csv, looks like:

A, B

1, aa

QVTab:
LOAD A,
      B,
      RecNo(),
      IterNo()
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
while RowNo() < 10;

The loaded result will look like:

RecNo  always sticks to 1 since there’s only one line in source data, while IterNo() will indicate the loop rounds in the final calculated table.

Q: QVD compress the data?

A: Yes. QVD always compresses the data into binary. In QlikView the column formats and correspondent beta-data will be saved as an XML header while data table will be compressed into binary. But in Qlik Sense, all data will be compressed into binary.

Q: Is KML is only used for maps in Qlik Sense? Can we use it in QlikView?

A:1. KML is basically an XML file with specific tags so that Qlik Sense loads KML files in the same way as normal XML files, but with special cares on coordinates. Therefore, once KML file is loaded, it can be used like all other data sources.

  1. KML is basically an XML file with specific tags so that Qlik Sense loads KML files in the same way as normal XML files, but with special cares on coordinates. Therefore, once KML file is loaded, it can be used like all other data sources.
  2. In QlikView, KML file is not a natively supported table file, however, you could force it to be loaded by setting ‘files of type’ to ‘All files’. The difference is that the contained coordinates will be treated as normal string instead.

Q: Can qvd file be password protected? How?

A: There isn’t any built-in feature for that. You can try a system file level protection.

Q: Does Qliksense support VB scripting like Qlikview?

A: No. Qlik Sense front-end is a web application made by Javascript/CSS/HTML. The Scripting way will be very much similar to QlikView Ajax client. However, VB scripting is supported in Qlik Sense.

Q: How to generate a KML file?

A: There are many third-party GIS applications could generate KML file, such as Google Earth and QGIS.

Q: Does Qlik Sense support any macros??

A: Qlik Sense doesn’t support any macro feature for now. Please check community and official roadmap.

Q: Does QlikView have some standard QVD for maps since the co-ordinates never change and can be standardized. Something like Power Map.

A: There isn’t any standard coordinates solution for QlikView. You can try to find a map extension in Qlik Market to support coordinates.

0 Replies