Qlikview Question-3

What is partial loading??

Partial Reload helps to add / replace data to QlikView Applications without reloading the complete application.

Usually When We do a full reload in QlikView application, QlikView drops all the tables from Memory and recreates the Table again from the Script But with Partial reload, we can reload only certain load/Select statement by Keeping other tables in QlikView Memory.

There are two Key Words by which partial reload can be activated in QlikView Scripting.

Add        - Append Data to Existing Table or Add New Table to your Data Model
Replace - Replace Existing Table.

Alternate to Generic load in Qlikview

I have requirement where one of my field values need to be converted to fields and their status should appear as their values

I used generic load to get my requirement but in the process i got the result without generic load 

I have field named Process where it has around 40 values and theirs statuses are in different field named as Status

It looks as below and i have primary field named as ID

Instead of Generic load i used below code to get the expected result 

InitialTable:

LOAD

    "ID",

    Process1,

    Status1

resident Processes;

FinalTable:

LOAD ID

Resident InitialTable;

FOR i = 0 to FieldValueCount('Process1')-1

LET vField = FieldValue('Process1', $(i));

If '$(vField)' <>'' then 

Left Join (FinalTable)

LOAD ID,

Status1 as [$(vField)]

Resident InitialTable

Where  Process1 = '$(vField)';

end if;

NEXT i

DROP Table InitialTable;

I got the result as below after execution 

  

New Features In Gmail 2018

Google is changing how Gmail looks and works.They launched the new Gmail back in April, but until now it’s been optional.Everyone will be switched over 12 weeks after the transition starts.

If you’re seeing the new Gmail for the first time you might be a little overwhelmed. To help you feel a little more at home, here’s a quick roundup of the new features and how to use them.

Hover Actions Let You Act On Messages More Quickly

You can archive emails, delete them, mark them as unread, or even snooze them. It’s a small feature, sure, but it makes interacting with emails a lot faster.

Snooze Emails So You Can Deal With Them Later

Gmail users can now snooze emails without any browser extensions. This removes emails from your inbox only to bring them back later, which is perfect for anything you need to act on eventually.

The functionality is simple: just click the Snooze hover function and choose when you’d like to see the email again. When the times up, the message shows back up in your Inbox.

his is a must-have feature for anyone who likes to keep their inbox clean, so check it out.

Suggests Replies and Can Autocomplete Sentences

“I hope you’re well,” “Looking forward to hearing from you,” “I hope you have a great day.” Emails tend to include a lot of sentences like this, which you’ve probably typed out hundreds of times over the years.

Confidential Mode Causes Emails to Self-Destruct

Email isn’t secure, but this feature can help. Confidential Mode causes emails to self-destruct, meaning whoever you send it to can only read it for a certain period of time. Your message is essentially stored on a Google server instead of being sent via email, allowing you to control who can see the message and when. This isn’t foolproof—the person you send it to could screenshot the email, for example—but it’s a nice little feature that can help keep your information private.

Questions on SAP connector clients 7.0

What are the SAP connector clients in Qliksense??

SAP Bex Connector
SAP SQL Connector
SAP Extractor Connector
SAP Info provider ConnectorSAP BAPI Connector


What are the objects supported by SAP Bex connector 7.0??


Bex Query
Composite Provider

What are the data types can not be downloaded using by the SAP SQL Connector??

A field in an SAP database table is assigned to a Data Type. Fields assigned to the following Data Types cannot be downloaded by the SQL Connector:

• LCHR (Long character string, requires preceding INT2 field)
• LRAW (Long byte string, requires preceding INT2 field)
• RAWSTRING (Byte String of Variable Length)

What are the Objects supported by SAP SQL connector 7.0??

DSO
Info Objects
Info Cube
ADSO

What is Delta load and which connector supports it??

Delta load is used when there are new records added. Instead of extracting all the records, we can extract records which are updated recently. Extractor connector supports Delta load 

What are the objects supported by SAP extractor connector??

DSO
Info Objects
Infocube
Hierarchy 

What are the info providers supported by SAP Info provider connector??

InfoCube
MultiProviderADSO
Composite ProviderOpen ODS view 


What is BAPI connector??

The BAPI Connector enables calls to Function Modules or BAPIs (Business Application Programming Interface) in an SAP BASIS System 6.40, 7.00, and later. The QA method of a BAPI is implemented as a Function module.

Qlikview Question -2

Binary Load

            Loading one .qvw file as a source into another .qvw file is called binary load.

• Only one binary load will be allowed within a .qvw file.
• It should be loaded as first line of the script before the set variables in first tab.
• Using binary we will get the data model from the another qvw file but not the front end object. Please find data model view in the below screen shot after binary load

Below is the sample code:- 

Binary  C:\users\.....\.........\binary.qvw;

How to convert .PGO to XML files in qlikview

As user license information stored in .PGO files in Qlikview, we can not see the information.We can convert them into XML files to get loaded into qlikview. We will see the process of converting PGO files to XML below.

(PGO files are stored in Root folder. you can find the root folder path under QMC > System > Setup > QlikView Servers > QVS@ > Folders tab > Root Folder field)

We can convert by changing parameter in Settings.ini file. Please open settings.ini file and change the parameter to PgoAsXmlAlso=1

Please find in below screen shot

Once the parameter is changed then save the file and restart the Qlikview server service. Now XML files are available in Root folder

Qlikview Question-1

Is there any function which creates Synthetic key in Qlikview?
Yes/No. Please comment if there is any function

Synthetic key is due to more than one common key between tables in Script. We don't have synthetic keys until there are no two common keys between tables. 
But when we use interval match function, It will create synthetic key as this is the nature of this function. Using proper join, we can remove this