QlikView 12.X end of support

Dear Qlikers,

We all know that QlikView will be stopping support for their products after 2 years of their release, here is some consolidated list, what you might be using...

Hurry up with your instance...

Best Regards,

Kiran Kumar 

Academic Program by Qlik for Students and professors

Hi Qlikers,
In continuation of my previous post-Qlik announced an academic program for students and professors where they can register the program and learn the technology.

Find the full details in the below link.

https://www.qlik.com/us/company/academic-program






Happy Learning 😊

No more free Qlik Sense Desktop after June 2020

All Qlikers,
Its a sad but true flash news for all of us, to improve the cloud and new business strategies Qlik has decided to cease the free usage of its Qlik Sense Desktop and Qlik Sense Cloud basic Free accounts.

Here is the original link ...
https://community.qlik.com/t5/Qlik-Support-Updates-Blog/Changes-to-Qlik-Sense-Desktop-in-2020/ba-p/1653306

How about QlikView to Qlik Sense migration...

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 about the reload time in Qlik Sense ?
4. How about the reduction of files into multiple files using Qlik QMC balanced using Qlik Sense QMC like Simple reduction or Loop & Reduce ?


My experience is as below
1. Should the data model also be migrated to Qlik Sense ?
Per now Qlik is providing Dual license for both QlikView and Qlik Sense so architects are in no position to disturb their bigger data models to be migrated into Qlik Sense. So what is the process here?

Data model will be still in QlikView but it is binary loaded into Qlik Sense for UI development.

2.What about the features that are there in QlikView and not there in Qlik Sense ?
Thanks to Qlik  for introducing a lot of features in Qlik Sense for the past 1 year or so but earlier it was a bit difficult to mimic the same look and feel in QlikView to Qlik Sense as there were no options or alternatives for getting them, but because of extensions this can be leveraged a bit but be careful to use them as they may not be trusted all the time to be intact with the latest version of Qlik Sense.

On the whole what I can say is we have to find new ways of presenting data to the user in Qlik Sense for scenarios where we don't have substitutes for QlikView like Hide & Show Mechanism.

3.On the whole how about the reload time in Qlik Sense ?
There is a lot of difference in this aspect and at times Qlik Sense may crash if the load time of the app is more.

What I can suggest regarding this is to have a data model in QlikView and do a binary load in Qlik Sense, if there is no Qlik View at all then plan to have multiple Transform apps for the same.

4. How about the reduction of files into multiple files using Qlik QMC balanced using Qlik Sense QMC like Simple reduction or Loop & Reduce ?

There is no way that this can be achieved using Qlik Sense QMC, the only way that can be used is
-> Create multiples apps with same UI and data model but use the expressions accordingly to limit the values
-> Create multiples apps with same UI and expressions but create multiple versions of reduced data models in QlikView and then use them in UI apps of Qlik Sense.This way works when your project is having both QlikView and Qlik Sense but the first option should be used if your data model and UI is also built in Qlik Sense.

Hope this helps for migration of projects....

Section access - Part1

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 has 4 Sales representatives who are selling multiple products for the company, now every sales representative wants to see the information of the products he sold at the end of a quarter or a month so that he wants he know whether he achieved his quota of sales or not for that quarter or month.

Solution:
Lets assume the information regarding the sales is captured in a data base and a BI tool is being used to show the data for the reps, now if a rep logged into the tool he has to see his sales only but not the sales of other rep, in this case section access is used to dynamically show the data of a rep who logged in rather than showing all the data in the qvw file of all reps.

How Section access is implemented ?
Section access is implemented in the script and by loading data containing the access information between two keywords... Section access               ...... Section Application;




Between Section access and Section Application commands one can load data from a qvd, excel, csv or from data base select command etc but the load command should have the following fields
in capital letters.

ACCESS, USERID,PASSWORD etc.

To know the list of fields that can be used you can go into 'Insert Menu->Section Access->Load Inline' and observe the wizard which appears.

Below is the screen which pops up after selection the above....

Note:
Section access feature can be tried in QlikView Desktop but it cannot be tried in Qlik Sense Desktop.
While trying Section access in QlikView Desktop ACCESS,USERID and PASSWORD fields are compulsory where as alternatively we can use OMIT and other 'Data reduction fields with them.

Hope you have understood the beginning of how to implement Section Access in QlikView,
will come up with an example next time for your practice.

Thank You................ and Happy Learning.

Loading a set of Excel files from a folder into QlikView

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 individually and this has to happen every time when we are loading the qvw file such that all the older files plus the new file should be loaded. This can be achieved with a loop in QlikView/ Qlik Sense, below is one such script which I used in my real time. Hope this helps you.


Note: One thing to be observed here is the name of the files are the same but with a different date at the end.

//Code Used:

let vQlikTech = 'Your Folder Path';

Directory $(vQlikTech);

let i= 1;

For each File in filelist ('Risk Register_*.xlsx')

Risks1:     //to get sequence Snopshot ID
Load
RowNo() as Test
AutoGenerate 1;

i= peek('Test')+i;

drop table Risks1;

Concatenate
Load
*,
Date(Date#(subfield(SubField(FileName(),'_', 2),'.xlsx',1), 'DD.MM.YYYY'))as "Snapshot Date",
'$(i)' as "Snapshot ID"
FROM $(File)
(ooxml, embedded labels, table is owssvr);

Next File;

What is Section Access - For Qlik Beginners

Good Day,
All of you.
To start with a simple quote.....

                                                 ** Repetition is the crux of Education **
Section access is one such topic which can be discussed for hours together as it has a greater usage in QlikView/Qlik Sense.

First of all
What is the use of Section Access ?
Lets take a simple scenario.
A university is maintaining students data in a data base and created some analytics over that and shared that files to all the Department heads using QlikView Access point. Now the rule here is when a Department head opens that file he has to see analytics of his students not the other department students.....

Hope you got the requirement. To make it simple

University contains - 7000 students
--------------------------------------------
IT Dept                   - 1000 students
ECE Dept               - 1500 students
MCA Dept             - 1000 students
MBA Dept             - 2000 students
Civil Dept              - 1500 students

Now if a Department head of IT Dept logs in to the file, how many students analytics he has to see ?
1000 - Correct!

This is section access, it means the original file is loaded with all students data but when a department head open the file he has to see his student data only.

This concept is also known as Data Reduction (or) Row Level Security as the security is on the data or on the rows.

Hope this makes sense on understanding What is Section Access in QlikView/Qlik Sense.


I will come up with some more concepts on Section access with examples to practice in my next posts.