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.