CategoryQlik View

Integrating Python from QlikView

I

Before trying anything from QlikView to execute a program outside of it. Please follow the steps mentioned in the below link.   I have created a small program for evenodd as below and saved it as evenorodd.pyBelow is the python programimport timenum = int(input(“Enter a number: “))if (num % 2) == 0:print(“Number is Even”)else:print(“Number is Odd”)time...

How about QlikView to Qlik Sense migration…

H

Dear All, I am back with some good to know information as always 😜. Now a days its common for a Qlik project to be migrated to Qlik Sense, at least the UI. I have been involved in such projects but I felt the below challenges… 1. Should the data model also be migrated to Qlik Sense ? 2. What about the features that are there in QlikView and not there in Qlik Sense ? 3. On the whole how...

How to Design a Data model based on a SQL query(Oracle) in QlikView

H

Dear All, It is a challenge to all of us to mimic SQL query into a Data model, quite often in the current project I face such challenges. One question you might ask is why not directly use the query in script and convert it as a qvd but in the architecture we are in right now we load most of the tables in to qvds and question comes when you have all the tables as qvds why can’t we create a...

Section access – Part1

S

Continuing my post on Section access introduction, I would like to give more insight into the topic.What is Section access ? Section access is a command in QlikView/Qlik Sense which is used to restrict data access on a qvw file or qvf file so that the person who is looking into the file would see only the data which is intended for him. Let me give a simple example, Business Scenario: A company...

Loading a set of Excel files from a folder into QlikView

L

Good Day, All of you. In the process of building a data model in QlikView/Qlik Sense sometimes we may require to load a set of files like .txt,.csv or .xlsx/.xls, but assume a case where we need to load a set of 100 files which are snap shots of data like complete weeks data kept on next Monday with a Date to it, like below. Now here is the task to load all the files at once with out loading them...

What is the difference between QlikView and Qlik Sense? In a layman view

W

I have been hearing this question from multiple people who want to learn QlikView or Qlik Sense but in reality both the tools are the same at the core architecture level(I mean QIX engine, associative model), but then what are the differences. QlikView is more useful for guided analytics, where Qlik Sense is useful for self service.           Phew! What are these...

Welcome All…..

W

Dear All, I am very glad today to create this blog so that I can share my experiences in Qlik world( QlikView, Qlik Sense). Things are too deep in Qlik as it is a wonderful tool which can be used as a Self Service and Guided Analytical tool.In this blog I would like to share some of the common things people like to know about Qlik, like technical things, common myths , some real time...

Kiran Cherukupally

Get in touch

Quickly communicate covalent niche markets for maintainable sources. Collaboratively harness resource sucking experiences whereas cost effective meta-services.

Open chat