Questions tagged [qlikview]

QlikView is a business intelligence platform created and distributed by Qlik Corporation. The main aim of the platform is to allow users to self-discover the data that they require using fast in-memory analysis via either a Microsoft Windows Application (QlikView Desktop) or via a web portal (QlikView Portal).

QlikView initially began life as "QuikView" ("Quality, Understanding, Interaction, Knowledge") when it was launched in Sweden in 1993 by Qlik's founders, Björn Berg and Staffan Gestrelius.

Later in 1996 it was renamed to its present-day "QlikView" as its customer presence increased. Since then, the QlikView platform has developed and matured into multiple components:

  • QlikView Desktop: A Windows-based application for in-memory data analysis

  • QlikView Server: A Windows-based server service that provides a way to view QlikView documents via a webserver, and also manage other QlikView components

  • QlikView Product Suite QlikView is a comprehensive business intelligence platform providing powerful business analytics to a broad range of users throughout the organisation. The QlikView suite is designed for application development and data extractions, efficient information distribution and powerful analysis for either the power user or end-user. QlikView can be deployed both offline and online leveraging a range of industry leading technologies.

  • QlikView Local Client This stand-alone Windows client provides the full developer’s ETL and end-user application to develop, deploy and analyse QlikView applications.

  • QlikView Small Business Edition Server This Server version of QlikView provides ones one central computer to handle all reloads, RAM performance and administration. Users can access the QlikView documents via a number of different Clients options – Windows full client, IE Plug in, Ajax (zero footprint) and mobile clients (eg. iPhone, BlackBerry etc). Two different user licenses available – Named Client Access License (CAL) provides one user access to as many QlikView documents as required or Document CAL which enables one user to access one document. Minimum deployment of 5 Named users, maximum of 25. Document CALs are a minimum of 10, with a maximum of 100.

  • QlikView Enterprise Edition Server This is the full enterprise Server version of QlikView, again providing centrality for QlikView reloads, RAM performance and administration. In addition this Server version allows nesting of multiple servers for data load balancing as well as enabling the collaboration feature for the users. Collaboration enables users to create and share their own objects and charts as well as bookmarks with other users.

    Named CALs, Document CALs, Session CALs (Concurrent) and Usage CALs are user license options available. Minimum deployment of 10 Named CAL and Document CALs are a minimum of 100.

  • QlikView Publisher: A Windows-based server service that provides a way to automate the publication of QlikView documents to a web portal, fileshares and end users.

    QlikView Publisher ensures that the right information reaches the right user at the right time. Developed for larger user environments, QlikView Publisher gives further centralised administration and management. QlikView Publisher allows for complete control of the distribution of a company’s QlikView applications through QlikView AccessPoint also automating the data refresh process.

Demonstrations

QlikView Demo Applications

Beginner Resources

Build Your First Application in QlikView (PDF)

References

QlikView Reference Manual (PDF)

1068 questions
1
vote
1 answer

Change color of distribution plot in qlik sense

I have a distribution plot in qlik sense: How can I specify the color of the dots? I want to change it based on the points. I have three different types of my x-axis 'Geschäftsverteilung' : 'On-Time', 'Delayed' and 'Late', so the on-time are red…
PV8
  • 5,799
  • 7
  • 43
  • 87
1
vote
1 answer

QlikSense Script Issue : I'm getting multiple records for some Casenumbers with different state like " Progress' & "On Hold"

LOAD number as [Case Number], number as key_case, short_description as Description, ApplyMap('map_CustomerDeliveryGroup',dv_company,'N/A') as CustomerGroupNo, mid(dv_priority,5) as Priority, dv_business_service as…
1
vote
2 answers

Has anyone integrated CKAN with Qlik, Tableau, and R? How did you do it?

I would like to know if anyone has created an environment where CKAN is the data catalog and it is integrated with data analysis and visualization tools like Qlik, Tableau, and R.
Markthepmp
  • 15
  • 3
1
vote
0 answers

Add second KPI to Qlik View distribution plot

I am using a distribution plot in qlik sense desktop Right now I have a Dimension Point: Column A Y-axis: column B x-axis: column C Right now I am only see the distribution of the x-axis in percentage, how can I add the absolute numbers to…
PV8
  • 5,799
  • 7
  • 43
  • 87
1
vote
1 answer

Qlikview Replace WeekSeq number with week number

I have a master calendar that includes week and weekseq, weekseq is just an autonumber of week and year. I am having an issue with the column labels on a 52 wk report that works of current week back 52 weeks. When i use weekseq as the column header…
PA060
  • 59
  • 1
  • 7
1
vote
1 answer

Avg of last 3 months

I have constructed a demo on there is problem of 3 month ratio I am looking for when it’s Jan it will show Jan amount, if Feb then sum(Jan and Feb), if March then (Jan and feb and mar), if apr then sum(feb,mar,apr). for April (Feb , March and…
1
vote
0 answers

special characters in qlikview

I am working with qlikvieww, and i have a problem with the special characters that are generated when we use the function TextBeween(myText). We have two transformations in the code, in order to get the date from a text: step1: …
Fatiso
  • 59
  • 8
1
vote
1 answer

qlikview MapSubString

I am using mapping load with MapSubString but it doesnt work for searching the sentence start and ends with text. For example : All below cases will be mapped with Network fault. Network Element fault Network Radio equipment fault Network had…
Ves
  • 21
  • 2
1
vote
0 answers

Possibility of using angular 2+ for writing Qlik custom extension

I am using qliksense for one of my data visualization project. I was wondering if it is possible to develop a Custom Qlik extension using angular 2+. Hours of searching online have not resulted in finding any tutorial or article regarding the same.…
Vikhyath Maiya
  • 3,122
  • 3
  • 34
  • 68
1
vote
0 answers

How to change background color of a cell/group in a Pixel Report in NPrinting Designer using C#

In NPrinting Designer (in the Pixel Perfect format) there is an option to use Conditional format which will color fonts/backgrounds according to a condition. This works for the 'rows' of a container/table but the same logic cannot be applied to the…
Saud
  • 480
  • 1
  • 9
  • 26
1
vote
2 answers

How to convert four-digit Julian (yddd) to Gregorian (mm/dd/yy, etc.) in script loader?

The Goal To have the data script handle the logic and conversion to a date format that is parsable/readable by a QlikSense/QlikView line graph. AKA it needs to be a normal format. (YYYYMMDD, MM/DD/YY, etc.) Context All relevant tables to the date…
bananabrann
  • 556
  • 7
  • 26
1
vote
0 answers

Minimum date against each policy

I have 2-3 multiple policies with same policy no like if i have policy 00/34 then there is 2-3 multiple records of this policies but other columns of this policy is different only policy_no is same .. i want to get minium date against policy like if…
1
vote
0 answers

policy status in script qlikview

i script but there is some problems image If there is multiple policies then i want first record which has min date always as "new" because this record came first against specific policy .. and other record which has same policy consider as "renew"…
1
vote
1 answer

QlikSense expression to find average duration over a period of time

I want to find the overall duration in hours over different periods of time. ie. once I add filters such as 'October' it should show me the overall hours for that month. I want to count duplicate lessons for multiple attendees as 1 lesson. ie. the…
toothsie
  • 245
  • 3
  • 10
1
vote
1 answer

Month Differences in qlikview

There is 2 dates column one is from date and second is to date .. and i want to get month difference from these two dates like if from date to date month difference 01-02-2019 02-02-2020 13 here 02 (feb) month 2019 till…
MIRROR
  • 61
  • 1
  • 2
  • 10