QlikView to Qlik Sense Converter

Great tool to Qlik community.

The QV Convertor tool is available from the Dev Hub in QS 3.2+.  It’s a pretty slick tool that converts QV Variables, Dimensions and Expressions to Master items and converts QV charts to Master QS Visualizations.  It does not attempt to replicate the sheets,  but expects you to place the visualizations on sheets yourself as required.

It’s a very useful tool with a good UI that allows for filtering and limiting what gets converted.

Reference: QlikView to Qlik Sense Converter

Advertisements

Amazon’s and Walmart’s latest moves confirm the death of the middle class as we know it

Amazon, whose Prime service claims more than 70% of upper-income households in the US — those earning more than $112,000 a year — is suddenly going after customers on government assistance who earn less than $15,444 a year for a one-person household.

The retailer on Tuesday announced it would slash the cost of its monthly Prime membership nearly in half, to $5.99 a month, for customers who have an electronic benefit transfer card, which is used for government assistance like the Supplemental Nutrition Assistance Program, better known as food stamps.

Reference: Amazon’s and Walmart’s latest moves confirm the death of the middle class as we know it

Guns kill nearly 1,300 children in the U.S. each year and send thousands more to hospitals

Handguns and other firearms cause the deaths of more children in the United States each year than the flu or asthma, according to a comprehensive new report on gun violence and kids.

Each day in the United States, an average of 3.5 people under the age of 18 are shot to death and another 15.5 are treated in a hospital emergency department for a gunshot wound. Between 2012 and 2014, an average of 1,287 children and adolescents died each year as a result of gun violence, making firearms second only to motor vehicle crashes as a cause of injury-related deaths. Another 5,790 were treated for gunshot injuries in U.S. hospitals.

Here’s another way to look at it: In the United States, a gun is the cause of death in more than 1 in 10 deaths of people under the age of 18.

The number of child fatalities related to guns is far higher in the U.S. than in any other high-income country. Another study has reckoned that the U.S. accounts for 91% of all the firearms-related deaths of children under 14 in the world’s 23 richest countries.

The new analysis, published Monday in the journal Pediatrics, represents an unusually comprehensive look at the toll that guns take on children.

Reference: Guns kill nearly 1,300 children in the U.S. each year and send thousands more to hospitals

Historical Comey Testimony

Ex-FBI director, James Comey, made a testimony on June 8, 2017, about Trump’s objection of justice investigation in front of US Senators. I write this summary to remember this historical moment in the future.

First of all, Senators overlooked the most important item in the testimony: If Trump admitted in public that he fired Comey to influence the investigation of Russian related to his campaign and the election, it’s a direct objection of justice! There is no need to argue the intention of the word “hope” that Trump used in their private meetings.

Second, the focus of the testimony is about Trump’s objection of the justice. Trump’s attorney misled US people by emphasizing Trump not being investigated for the Russian intervention. They are not the same topic. The attorney and the administration are distracting people from the center of the testimony again by making alternate fact.

Third, beyond the testimony, rational people would understand that Trump is lying about the truth all the time. With this, how do we educate our kids about honesty now? What promise can Trump’s words provide anymore?

Forth, Senator McCane was confused between Clinton email incident and Russian meddling US election. Clinton email incident was completely investigated and no crimes were found. That’s why it was closed. Clinton email incident did not involve Russian, although Democratic Party email leaks are Russian related. And, the reason that Trump’s campaign being still open investigation is because of Russian involvement. These are different and separated criminal investigations, and the same reason why one is closed but the other is still open, even if they happened during the same 2016 US election.

Fifth, some senators claimed Comey leaking classified documents, which is not correct. Comey did not hand out classified “documents”. He handed out the “recollection” of his memory of his conversation with Trump to a reporter as a private citizen after he got fired so it’s a debate about whether his memory note written later could be counted as classified or not.

Reference:

Clapper: Democracy ‘under assault’

Donald Trump’s win was predicted by Allan Lichtman — the US election expert who has called every result since 1984

Relationship Quiz

DataRobot comes out with a machine leaning model to predict relationship via 6 questions. Check it out here.